Access 2007 flle moved and gets a path error

  • Follow


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,
0
Reply Utf 3/11/2010 10:21:01 PM

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

"Janis" wrote:

> 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,
0
Reply Utf 3/12/2010 2:56:01 AM


"Janis" <Janis@discussions.microsoft.com> wrote in message 
news:A7D04036-9278-409E-AD2D-BD34233E7816@microsoft.com...
>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, 

0
Reply De 3/13/2010 5:24:36 PM

On Thu, 11 Mar 2010 18:56:01 -0800, Janis
<Janis@discussions.microsoft.com> wrote:

>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
 
0
Reply Armen 3/14/2010 4:18:52 PM

3 Replies
433 Views

(page loaded in 0.332 seconds)

Similiar Articles:
















7/28/2012 10:51:42 AM


Reply: