Creating an .mdb file via VBA

[Dave Punky]

Hi all,

This may be something obvious but I simply want to create a new .mdb (Database) file via VBA code.

I would normally enable the Access reference in VBA and just create a new database that way, however the system where I plan on using this doesn't have Access references so I need to create the file generally and add the tables using DAO Objects to create tables/fields via SQL.

Basically I just need to be pointed in the right direction for creating the files to begin with if anyone can help?

 

[xenou]

Allen Browne has a full set of sample code for DAO here:
Microsoft Access tips: DAO Programming Code Examples

I prefer DAO generally when working with Access specifically. Don't believe many old posts from a few years ago that stated it's demise. But for completeness I'll note that ADO examples are also available at the same site:
Microsoft Access tips: ADO Programming Code Examples

 

[Dave Punky]

Hi xenou,

Thanks for the links, outlines everything I needed and answers a few other questions I had!