MS Access Help: Copying database Relationships

[news.giganews.com]

Does anyone know if there's an easy way to export or copy the relationship
structure from one mdb to a new one? The relationships in the db are time
consuming to reproduce. I am trying to make a copy of a database including
all the relationships, forms, queries and modules while still within the
original database. This has to be a relatively automated process (button
click). Any suggestions?

 

[aaron.kempf]

yeah; use ACCESS DATA PROJECTS and you can do this all through TSQL.

-aaron

 

[Sylvain Lafontaine]

Instead of Exporting, make: Get External Data --> Import... All the
existing relationships will be imported with the tables. Click on the
Options button on the Import dialog window to have more choices.

Also, I don't see your need to have made that much crossposting.

 

[Dale Fye]

Check out the CreateRelation method in Access Help. There is an example
there.

I have not done this, but it looks like once you have copied all the tables
over from one db to the other, you then need to loop through the Relations
and use the CreateRelation method. In addition to looking at Help, you
might want to Google on Access +CreateRelation, I got over 800 hits.

HTH
Dale