I vaguely remember doing something with the Office 2010 ACE drivers, but I don't remember it well. All of our Access stuff was converted to SQL 2008 so I don't even have an example.
At least this might get you started. Steve -----Original Message----- From: Russ Michaels [mailto:[email protected]] Sent: Tuesday, September 25, 2012 9:05 AM To: cf-talk Subject: msaccess on 64bit I know this is a sore subject, but the customer needs it for a legacy system and no moving to MSSQL or MySQL is not an option right now. I can get the DSN's working manually by doping this. create DSN via %systemdrive%\Windows\System32\odbcad32.exe and then via %systemdrive%\Windows\SysWOW64\odbcad32.exe and then create an ODBC socket DSN via the CFADMIN to point to that DSN. However this is a PITA and the client really needs to be able to create them himself via the cfadmin, is there any better workaround that get the "Microsoft access" DSN in the cfadmin working again on 64bit ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
