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???.