Solved: Copy and create relationships [Archive]

View Full Version : Solved: Copy and create relationships

ViolettePhan

08-02-2006, 03:26 PM

Hi all,

I was able to create a new database (called NewDB.mdb) and tables structure via VBA from a linked database(OldDB.mdb) while in current application (myProject). Now I would like to copy the existing relationships (OldDB.mdb) and create the same one to the new created database (NewDB.mdb).

If anyone know how to do it, please help...

Thanks in advance...
Violette

stanl

08-03-2006, 03:14 AM

this uses ADOX

http://support.microsoft.com/?kbid=304322

Stan

ViolettePhan

08-03-2006, 08:06 AM

Hi Stanl,

Thanks for the link, I will check it out...
Best,
Violette

ViolettePhan

08-03-2006, 11:50 AM

Hi Stanl,

Thanks for your help. I tried your suggestion and other ways but all did not work so I make a template database and use FileCopy method to do the job.

Best.
Violette