You cannot natively run msaccess on 64bit windows as there is no 64bit jet driver, it is now legacy and Microsoft no longer support it. There is also no longer any 32bit version of windows since 2008 r2, its all 64bit now. If you seatch on Google there is a work around to get it to work with the old 32bit jet driver. I have not found any way to have this work automatically so you can just setup the dsn in cfadmin and it works.
Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Mar 9, 2013 11:25 PM, "Ben Conner" <b...@webworldinc.com> wrote: > > Funny you should mention that. These are production client databases and > I am > not really authorized to 'fix' them, but I'm installing the 64 bit vsn of > Access > now and seeing if I can update them to 64 bit after I finish the install. > Just > as soon make them all SQL 12, but that isn't my call. > > --Ben > > On 3/9/2013 3:22 PM, Money Pit wrote: > > Don't have an example handy cuz I don't use Access, but what about > > using dbtype 'Other' and manually specifying the strings? the way we > > used to have to do when mySQL support was dropped a few years back? > > > > 64-bit CF vs. 32-bit is so much more capable I'd do whatever it takes > > to NOT go back to 32-bit if I were you. > > > > p.s. notice how I didn't say anything snotty about using Access? :-) > > > > > > -- > Ben Conner b...@webworldinc.com > Web World, Inc. 888-206-6486 or > PO Box 1122 480-704-2000 > Queen Creek, AZ 85142 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:354915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
