Question:
I have a program in VB6 using an Access 97 database. The code I use for all my procedures is as follows:
Dim db as DatabaseSet db = DBEngine.Workspaces(0).OpenDatabase("biblio.mdb", False, False)
It works fine with an Access 97 .mdb, but with a 2000 .mdb it pops up an error. How do I correct that? Thanks!
Answer:
Be sure that you’re using the Jet 4.0 library in your application. It can read both 97 and 2000 databases. Jet 3.51 cannot read 2000 databases.