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

When you installed Access did you choose 64-bit or 32-bit version ?

Open Access and use File->Help to see under About Microsoft Access (on right)

Mine shows Version 14.0.7232.5000 (32-bit)

Udpdate : to check which drivers you have use

Control Panel -> System and Security -> Administrative Tools

Then select ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). Select Drivers tab.

poj

Comment on Re^5: Update: Using Perl to connect to an Access 10 database Select or Download Code

Replies are listed 'Best First'.
Re^6: Update: Using Perl to connect to an Access 10 database by merrymonk (Hermit) on May 31, 2019 at 12:15 UTC
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?	[reply]
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]