Is it possible to convert a Database Access 97 to Access 2003 using VB6?

Question

I have a project in VB6 with a DB Access 97.

I need to convert the format to Access 2003 or newer.

Is this possible using VB6 code?

Answer 1

Using DAO in VB6, create a new database in JET 4.0 format:

DBEngine.CreateDatabase "c:\test\db4.mdb", dbLangGeneral, dbVersion40 

Then copy all objects from the old database to the new database.

More info here.