Convert linked table to local without losing relationships

[Guest]

Hi,

I'm converting a linked table to a local copy but when I do lose the
relationships in the relationships window.

How can I swap the local and linked so I can preserve the relationships.

Is this possible? There are a lot of relationships to recreate!

Any help would be greatly appreciated
Thanks in advance
Janet

 

[Guest]

Open a copy of the linked database.

Import all the forms, reports, queries, everything from
the forms/reports database into the copy of the
tables database.

(david)

 

[Guest]

Thanks,

Doing that way round makes sense

Janet

Open a copy of the linked database.

Import all the forms, reports, queries, everything from
the forms/reports database into the copy of the
tables database.

(david)