469,282 Members | 1,843 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

MS Access Help: Copying database Relationships

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?
Nov 13 '05 #1
3 6849
yeah; use ACCESS DATA PROJECTS and you can do this all through TSQL.

-aaron

Nov 13 '05 #2
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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
"news.giganews.com" <an*****@cambria.com> wrote in message
news:3P********************@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?

Nov 13 '05 #3
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
"news.giganews.com" <an*****@cambria.com> wrote in message
news:3P********************@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?

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Jelmer | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
7 posts views Thread by Ruben Baumann | last post: by
reply views Thread by Mark Lubratt | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.