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

copy relationships

P: n/a
n my work i often do copy all the objects of the database to a new
database.Can i also copy the relationships instead of creating them
anew? Is there a command in Access to copy all the relationships ?

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
SaveAsText 6,"","NameOfNewDB" will create a new db including tables and
relationships. After running this, you can transfer your forms, reports
etc.

There is code (called something like save objects as text) to do the
whole thing in
http://ffdba.com/downloads/downloads.zip.

If you have an frontend-backend then you will have to run the code from
the backend (or from a separate instance of access). Getting around
security issues may be a problem.

Nov 13 '05 #2

P: n/a
The relationships follow the objects to your new mdb. However, the
"new" relationships don't follow same format as the mdb you're copying
from.
solar wrote:
n my work i often do copy all the objects of the database to a new
database.Can i also copy the relationships instead of creating them
anew? Is there a command in Access to copy all the relationships ?


Nov 13 '05 #3

P: n/a
When you import tables from another database, there's an Options
button,which displays a checkbox to import relationships as well. In my
copy of Access 2000, it seems to be checked by default.

"solar" <sp*******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
n my work i often do copy all the objects of the database to a new
database.Can i also copy the relationships instead of creating them
anew? Is there a command in Access to copy all the relationships ?

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.