Link to home
Start Free TrialLog in
Avatar of tom_szabo
tom_szabo

asked on

MS-Access How to change path in front-end to the data?

Hi,
I have an MS-Access database and a frontend also an .mdb file. It seems like the front-end has the PATH to the actual data hardcoded in. I need to change the position of the actual data but have no idea how and where can I change the path that is hardcoded...

If I change the path, the program starts and comes up with an error and goes into debug mode...

I am certain it is a simple thing but since I have little experience with MS-Access it is a hurdle for me...

Thanks In Advance,

Tom
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

from the Access menu:

Tools>>Database Utilities>>Linked Table Manager

mx
This will show the current Path ...
Select All ... then Browse to the new location ...

That should do it ...

mx
Avatar of tom_szabo
tom_szabo

ASKER

Where? In the front end? How do I open it in the way to access the menu?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
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