Re^6: Update: Using Perl to connect to an Access 10 database

I have exactly the same data for the Version of Access.

Following your 'path', the Drivers tab says the File is ODBCJT32.DLL.
Does this mean that I can only use a 32 bit Perl to connect to the current version of Access or is there some way of using a 64 bit Perl with this Access?

As an alternate, is it likely that if I re-install Access as 64 bit I then can use the 64 bit Perl? If I do this do I also have to re-install other parts of Office 10 so that all are 64 bit?

Comment on Re^6: Update: Using Perl to connect to an Access 10 database

Replies are listed 'Best First'.
Re^7: Update: Using Perl to connect to an Access 10 database by stevieb (Canon) on May 31, 2019 at 13:43 UTC
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] [d/l] [select]
Re^7: Update: Using Perl to connect to an Access 10 database by poj (Abbot) on May 31, 2019 at 13:48 UTC
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]