copy relationships

[solar]

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 ?

[lylefair]

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.

[manning_news]

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 ?

[MacDermott]

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 ?