Access 2007 flle moved and gets a path error

[Janis]

I have a question on opening a client's file I get this error.

It can't find the path. E:\Mineral Tracker - Cleaned
Backup\mineralTrackerDataDase.accdb ' is not a valid path. Make sure that
the path name is spelled correctly and that you are connected to the server
on which the file resides.

I guess the client had it on the E:\ drive. In any case I went to the
External Data/Access tab and put in the new path.

The file opens but I keep getting this error. How can I fix the path?
thanks,

 

[Janis]

Sorry I discovered the database has a link to backend file that seems to be
missing.

 

[De Jager]

I have a question on opening a client's file I get this error.

It can't find the path. E:\Mineral Tracker - Cleaned
Backup\mineralTrackerDataDase.accdb ' is not a valid path. Make sure that
the path name is spelled correctly and that you are connected to the
server
on which the file resides.

I guess the client had it on the E:\ drive. In any case I went to the
External Data/Access tab and put in the new path.

The file opens but I keep getting this error. How can I fix the path?
thanks,

 

[Armen Stein]

Sorry I discovered the database has a link to backend file that seems to be
missing.

First, use Linked Table Manager to set up linked tables to your
back-end database. Use UNC paths (starting with \\MyServer\") instead
of mapped drive letters.

Then, if you want a more automated approach to relinking tables,
you're welcome to use our free J Street Access Relinker on our J
Street Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com