My Database and Backup have been moved to another location

S

SeekerFan

The database I created and its backup were moved to another server location,
when I opened the Front-end part of the database, it cannot locate the tables
that were in the backup. When I tried to open up the tables in the backup,
it can't locate them either. Is there a way to get those tables back?
Thank you,
 
K

Klatuu

The FE stores the links as paths to the BE location. You will need to open
the FE and run the Linked Table Manager to indentify the new location.
 
J

Jerry Whittle

You need to open up the Linked Table Manager and re-link those tables.

I'm a little confuse about not being able to find the backup tables in the
backup database. Were they linked also? In that case you need to relink them
also in the backup.
 
D

Dorian

In your front end, go to Tools--Database Utilities--Linked Table manager.
Select all tables and specify 'prompt for new location', then specify the
new location of the back-end tables.
These instructions assume you are using Access 2003.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top