CreateDatabase method (A2003)

Topic

New Reply

Is it possible to create a 2003-format file using the CreateDatabase method? So far, I have only been able to create a 2000-format file using this command:

CreateDatabase sName, dbLangGeneral, dbVersion40

Reply | Quote

Replies

No, the DAO CreateDatabase method creates a plain Jet 4.0 database. It only becomes an Access database (with all the extra stuff) the first time you open it in Access.

To create an Access 2002/2003 format database (which I don’t recommend, by the way) in code, you’d have to create another instance of Access using Automation, set the default database type to Access 2002/2003 format and use the NewCurrentDatabase method. You cannot do that from the instance of Access running the code, because code execution would end the moment you created a new current database.

Reply | Quote