Moving a database

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

I have a database that was given to me, it has been split. when I try and
open it, it is still looking for he original path. How can i change the path
so it will work on the new machine?
 
Use the Linked Table Manager.

In 2003, you access this from the Tools -> Database Utilities -> Linked
Table Manager.

When the linked table manager dialog box comes up check the box at the
bottom left "Always prompt for new location", and click the Select All
button. Then click OK.

The manager will ask you to identify the new backend database and will link
all of the tables to that database (if they exist).

HTH
Dale
 
Hi Dale,

Thanks for the response. The manager is greyed out in the front end, so cant
open it. any ideas?
 
Pardon my intrusion...

Is your "Front-End" an .mdb file or an .mde file? If the latter, you can't!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top