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 ? -- -- Russ Michaels www.bluethunderinternet.com  : Business hosting services & solutions www.cfmldeveloper.com        : ColdFusion developer community www.michaels.me.uk           : my blog www.cfsearch.com             : ColdFusion search engine ** *skype me*                     : russmichaels

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 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 ?