Access 97 ODBC driver

[glynch]

I wrote an application in VB that uses ODBC to connect to an Access database. This works fine for one client machine who is running Access 2000 (Windows 2000 Pro). But the second client is running Access 97 on Windows 98, and it seems like the connection isn't working. I am using a SQL Insert statement to dump data into an Access table to produce a report. I copied the SQL Insert statement from my VB application into the Access 97 database and it ran fine, so I am thinking it must be something with the DSN or the driver. I tried finding an ODBC driver for Access 97 on the Microsoft site, but I haven't had any luck yet.

The driver I am using now is Microsoft Access Driver (*.mdb), version 4.00.6019.00, ODBCJT.dll, dated 05/08/2001. Does this driver not work for Access 97?

I would appreciate any help I could get.

Thanks, Gerry

 

[jeremie_ingram]

Not sure if this will solve you problem, but it cant hurt. Try updateing the MDAC on the older version.

 

[glynch]

Thanks but I already did that.