Link to home
Start Free TrialLog in
Avatar of gtrapp
gtrapp

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gtrapp
gtrapp

ASKER

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.
Avatar of gtrapp

ASKER

I think the questions were on track, but I found the solution on my own.