New 64bit pc with Windows 7 Home Premium.
MS Office Pro 2010 - tried both 32 bit and 64 bit with same results.
An existing Access 2003 .mdb which I need to connect to, to build a website using a vbs script (combined with html docs and css etc)
This script works fine on my old 32 bit pc with Windows XP Pro and Access 2003.
Had the initial problem of the ODBC Data Source Admin not working at all but reconfigured it to C:\Windows\SysWOW64\odbcad32.exe and was able to add the target database under the System DSN.
But when I run the script the last line immediately below creates the following error.
'-- Connect to database
'Specified driver could not be loaded due to system error 193: (Microsoft Access Driver (*.mdb)
Sources: Microsoft OLE DB Provider for ODBC Drivers'
odbccjt32.dll is in both the system32 and SysWOW64 folders
Should the ODBC connection be using the SysWOW64 folder? and, if so, how do I change the setup please?
Or is it something else?
I first installed a 32 bit version of MS Office Pro including Access 2010, and then, when that did not work, uninstalled it and tried a 64 bit version, but same error.
Any help would be appreciated. I have changed the DSN etc settings in the ODBC Data Source Admin several times now - is there a way to get back to a clean ODBC Data Source Admin without rolling back everything else?