By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 3,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

MS Access Help: Copying database Relationships

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
yeah; use ACCESS DATA PROJECTS and you can do this all through TSQL.

-aaron

Nov 13 '05 #2

P: n/a
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

P: n/a
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.