Problem with Jet DB 4.0

[Steve Thomas]

I have a VB6 application that uses ADO to connect to an Access97 DB. I use the following statement when connecting.

Provider=Microsoft.Jet.OLEDB.3.51;Data Source=ACCESS97.MDB;

I recently changed to the following

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ACCESS97.MDB;

I did this per microsoft's directions so that a few issues would be resolved in ADO.

However, I have 10 users of which two now get error messages with the new setting. I created a new installation and executed it hopeing this would copy the neccessary files. Did not work. Anyone know why this might be happening on a select few PC's???.

[dcarlson]

What's the error?

[Steve Thomas]

The errors seem to be sporatic but I consistantly get an error when I try to do an .AddNew, .Update. The error it gives is "ERROR OCCURRED".

I am going to install the MDAC version 2.5 which will load the Microsft Provider 4.0 even though it should have been added during install. VB6 loads Version 2.1 and I have loaded the Version 2.5 on some of the other PC's that are working. I don't think this is the problem but it is a start.