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
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
This will show the current Path ...
Select All ... then Browse to the new location ...
That should do it ...
mx
Select All ... then Browse to the new location ...
That should do it ...
mx
ASKER
Where? In the front end? How do I open it in the way to access the menu?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Tools>>Database Utilities>>Linked Table Manager
mx