Thanks. Their conversion utility was just close enough to be deceptive. There are a couple of data formats in access that don't translate worth a damn to SQL server. Details have faded by now.
Thanks! Ben > On Nov 5, 2013, at 8:17 AM, "Mark A Kruger" <mkru...@cfwebtools.com> wrote: > > > Ben, > > Moving from MS Access to MS SQL is one of the easiest options for migration > I'm afraid. > > FYI you CAN get Access running on 08r2 with CF 64bit. It just takes some > work. > > -Mark > > -----Original Message----- > From: Ben [mailto:b...@webworldinc.com] > Sent: Tuesday, November 05, 2013 9:07 AM > To: cf-talk > Subject: Re: Problem with data formatting in CFINSERT > > > Hi Russ > > For those of us who have been out of the loop for a while, can you suggest > easy to implement alternatives to 32 bit MS access? I did a conversion of a > DB to SQL server some years back and that was painful. > > Ben > >> On Nov 5, 2013, at 7:52 AM, Russ Michaels <r...@michaels.me.uk> wrote: >> >> >> well someone has to say it... >> but why the frack are you still using MSACCESS when there are so many >> better/free alternatives? >> you know the Jet driver (which is what you use to connect to MSACCESS) is >> no longer supported by Microsoft and ha snot been for years and only runs >> in 32 bit, and as such does not work on modern 64bit OS (without lots of >> hacking to get it to run in 32bit mode), which is Windows Server 2008 >> onwards, there is no 32 bit windows any more. >> >> >> >>> On Tue, Nov 5, 2013 at 2:44 PM, <> wrote: >>> >>> >>>>> I have robot updaters and inserters too (made all the more robotic with >>> the >>> help of cfdbinfo figuring out the field types), >>> >>> This is what I do, but using my own CFX_ODBCinfo I developped years > before >>> cfdbinfo was available, >>> and I'm still using it because cfdbinfo doesn't work for Access > databases. >>> >>>>> Debugging is miserable with a layer of >>> code in the middle and straightforward without. >>> >>> Right, I think I'm going to improve my CF_INSERT tag by generating the > SQL >>> code in the tag. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm