Linked tables and copy

[TimG]

Hi,

I was just asked to make a copy of the Access database we are using. It is made by someone else then me, I just need to create an (empty) copy of this database.



What I have is a database cms.mdb that is full of linked tables. These linked tables link to another database cms_data.mdb, which contains all the data.

Now I want a copy of the cms database so I can clear all the data of cms_data_new.mdb to show to a new customer.

I copied all the files to a new location, but the linked tables in the cms_new.mdb database still link to the original database.

My question is now: How can I edit these links or what would be the best solution to make a copy of the database? I hope I am clear enough on this one.

Thx in advance!

[dcrake]

Go to Tools > Link Table Manager and point to the new back end to refresh the links.

David

[TimG]

Thx alot for the reference. Works like a charm .