Copying relationships to an identical db

[Guest]

I just copied all the tables, queries, forms, reports, etc from one database
to a new, now identical database to solve a workgroup security problem.

I have about 50 tables and a lot of relationships in the relationships
screen in the original database.

Is there a way to copy the relationships to the new database so that I do
not have to try to recreate them all. Program code will do just fine if it
possible.

Thanks
Peter

 

[Roger Carlson]

How did you copy them? If you Imported them from the New database (File>Get
External Data>Import), it will copy the Relationships by default. However,
if you want to check, on the Tables tab, click the Options> button.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I just showed the two databases side by side, then dragged from one window to
the other. I'll try the get external data option.

Thanks