Creating a new MS Access db from another

DrSnuggles

Well the hell is Hudson??
Local time
Today, 15:03
Joined
Sep 14, 2004
Messages
117
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!
 
You will need to create a Workspace object and then use its createdatabase method

Dim wrkSpc as WorkSpace

wrkSpc.CreateDatabase(.....
 
2 - Try the createdatabase method!
 

Users who are viewing this thread

Back
Top Bottom