My Database and Backup have been moved to another location

  • Thread starter Thread starter SeekerFan
  • Start date Start date
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,
 
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.
 
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.
 
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".
 
Back
Top