Access 2000

[J_BEYTIA]

When I use the form wizard in Vb6 to connect to an Access 2000 database I get the following message "Unrecognized database format" But when I connect to the same database in Access 97 I don't recieve any errors. Anybody out there know the answer?

[softwareguy74]

The problem is that the form wizard is using the Jet 3.51 driver which is not compatible with Access 2000. You need to use the Jet 4.0 driver to connect to Access 2000.

If you want to stick with the wizard, you can save your current Access 2000 database as an Access 97 format. Then, use your wizard to contact to the converted database. Once it has create the form/code for you, you can edit the code to point to your original Access 2000 database and change the Jet driver to the 4.00 version.

This is the solution that I use although someone may have a better fix..

Let me know if you need more detailed instructions on how to do the above..

Dan

[PaulLewis]

In an App I have, the connection strings as recorded in an ini file I maintain are:

ConnectionString1=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB2000.mdb;Persist Security Info=False

ConnectionString=Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\DB97.mdb;Persist Security Info=False

You need to use the correct connection string for the different DB engines. The OLEDB.4.0 engine will read Access97 however when distributing your client, the user will need to have the engine already (or I think they will need to download it from MS).

Regards