Saving Relationships

Hi. I seem to remember seeing something about this in a
past post but I cant find it using search. Is it possible
to make a copy of the table relationships and use it to
easily set up the same relationships in another db?

Im thinking of the advice sometimes given to copy all
objects to a new db, where corruption is suspected. This
would be relatively simple but redoing all the
relationships could be tedious with a db having many
tables.

Thanks, Noel

On Mon, 1 Nov 2004 08:03:24 -0800, "Leon"
wrote:

Hi. I seem to remember seeing something about this in a
past post but I cant find it using search. Is it possible
to make a copy of the table relationships and use it to
easily set up the same relationships in another db?

Im thinking of the advice sometimes given to copy all
objects to a new db, where corruption is suspected. This
would be relatively simple but redoing all the
relationships could be tedious with a db having many
tables.

Thanks, Noel

The Import Tables screen has a checkbox to specify that you want to
import the relationships.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

Thanks John. Ive had a look at that and its perfect.
Perhaps what I remember seeing related to an older
version of Access that didnt have this feature. Thanks
again, Leon

-----Original Message-----
On Mon, 1 Nov 2004 08:03:24 -0800, "Leon"
wrote:

Hi. I seem to remember seeing something about this in a
past post but I cant find it using search. Is it
possible
to make a copy of the table relationships and use it to
easily set up the same relationships in another db?

Im thinking of the advice sometimes given to copy all
objects to a new db, where corruption is suspected.
This
would be relatively simple but redoing all the
relationships could be tedious with a db having many
tables.

Thanks, Noel

The Import Tables screen has a checkbox to specify that
you want to
import the relationships.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.