View Full Version : Creating a new MS Access db from another


DrSnuggles
11-07-2007, 06:23 AM
I have looked around forum but cannot find any info on this.
I'm basically upgrading from MS Access Version 2 ( . . I know!) to MS Access 2003.

Here's what I'm trying to do:
1. Loop through a bunch of files (MS Access Version 2 *.mdbs) in a Sorce Folder and capture names in an Array.
2. Create MS Access 2003 dbs with names derived from the Array.
3. For each new db import all table objects.

I need help with point 2 especially.
Point 3 I can find out myelf.

Any help will be appreciable, Thank you in advance!

KeithG
11-07-2007, 06:32 AM
You will need to create a Workspace object and then use its createdatabase method

Dim wrkSpc as WorkSpace

wrkSpc.CreateDatabase(.....

Guus2005
11-07-2007, 06:32 AM
2 - Try the createdatabase method!