I wasn't very clear in my first post here. You don't have to re-install anything here. What I meant originally was:
- run the %systemdrive%\Windows\SysWoW64\odbcad32.exe command, and set up your DSN
- run the %systemdrive%\Windows\System32\odbcad32.exe command, and set up your DSN, *again*
Each of those corresponds with each platform. The first is the ODBC manager program for 32-bit, and the latter is for 64-bit. The DSNs for each version are stored separately (at least the system DSNs are, but I digress). After you've got your DSNs set up for both platforms, everything should just work.
| [reply] [Watch: Dir/Any] [d/l] [select] |
if I re-install Access as 64 bit I then can use the 64 bit Perl
Maybe, but I don't think the 64 bit ODBC driver is on the install disk so you need to download it. See 64bit v 32bit and be aware that "Compiled Access databases, like .MDE and .ACCDE files, won’t work unless they are specifically written for the 64-bit version of Office." and all the other caveats under "Reasons to choose the 32-bit version"
do I also have to re-install other parts of Office 10 so that all are 64 bit?
Yes, that is how I read it
poj | [reply] [Watch: Dir/Any] |