Creating a seperate database in VBA

message from Ryan on 19 May 2004
I was wondering if there was a way to create a seperate
database in VBA code. What I'm wanting to do is create
the database, then populate it with certain items using
the TransferDatabase method. Any suggestions are welcome.

Thanks,
Ryan
 
Cheryl Fischer replied to Ryan on 19 May 2004
This can be done using the CreateDatabase (DAO) method. Check it out in
VBA Help for detailed information.
 
Roger Carlson replied to Ryan on 19 May 2004
On my website, see sig below, is a small sample database that does just
that. Look for: "ImportToTempDatabase2k.mdb", which creates a temp
database, exports and empty table to it, relinks the table back to the main
database, then uses this temp table for importing data. This is done to
eliminate the bloat that can occur when data is imported to a native temp
table.
 

Archived message: Creating a seperate database in VBA (MS Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.