Path not valid when opening a query in Access 2007

When attempting to open a query in Access 2007 from the Navigation Pane, I see this error message:

'\\server\apps\timbersales\current' 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

How can I change this path, so the query opens up?
gtrappAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Helen FeddemaConnect With a Mentor Commented:
We need more information.  Presumably the path is for a table on a server.  Could the drive letter be different in this configuration?
0
 
RDWaibelConnect With a Mentor Commented:
Do you know where the query is?
0
 
gtrappAuthor Commented:
Actually, I think I figured it out. The queries are using a linked table, an Excel spreadsheet file and Text file. So, I found the link table manager and change the paths to these 2 files. The queries are now working.
0
 
gtrappAuthor Commented:
I think the questions were on track, but I found the solution on my own.
0
All Courses

From novice to tech pro — start learning today.