I need to create a database with VBA, but the database has to be in access 2000 version. This works fine when using Office 2003, but some users have recently update to Office 2010 and the DBs created are in the 2010 format.
Help?
Printable View
I need to create a database with VBA, but the database has to be in access 2000 version. This works fine when using Office 2003, but some users have recently update to Office 2010 and the DBs created are in the 2010 format.
Help?
Nevermind. I found it.
CreateDatabase([name],[connect],dbVersion40)
Works like a charm.
please mark the thread as closed use the tools at the top of the thread