Connection String Issue to Access

[trenier]

I have the following connection string that apparently is causing an error "Could not find installable ISAM" error when I open the Excel 2010 file on Windows 7. The queries in the file connect to an Access 2002 database.

I installed the "Microsoft Access Database Engine 2010 Redistributable" as recommended and get the same error. Someone mentioned that the error could be caused by the connection strings that I am using. Below is an example of one of the connection strings. Any ideas?


DBQ=S:\TSB-TB-Transmission\TBOMainFolderDND\ScoreCard Tracking Application\ScoreCard Data.mdb;DefaultDir=S:\TSB-TB-Transmission\TBOMainFolderDND\ScoreCard Tracking Application;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;


[h=1][/h]

 

[jscranton]

Have you checked here:

Access connection strings - ConnectionStrings.com

Check the syntax on this ODBC Driver section[h=2][/h]