How to change fixed path?

[denis_bernicky]

I have been given a database on a CD to do some work on. The only
problem is that when I open a form it tells me that the file path
//server/database/mydb.mdb is not valid. Of course it isn't valid the
whole thing is on my comp at the moment and not even on a network.

How can I change this path so that I can work on the database locally
and change it back when I put the changes back?

Thank you for any help.

Denis.

 

[Bruce M. Thompson]

I have been given a database on a CD to do some work on. The only

problem is that when I open a form it tells me that the file path
//server/database/mydb.mdb is not valid. Of course it isn't valid the
whole thing is on my comp at the moment and not even on a network.

How can I change this path so that I can work on the database locally
and change it back when I put the changes back?

Use the "Linked Table Manager" to point to the new location of your data file.
In Access 97, it's located under "Tools, Add-ins" and in Access 2000, and later,
it's found under "Tools, Database Utilities".

 

[denis_bernicky]

Use the "Linked Table Manager" to point to the new location of your data file.
In Access 97, it's located under "Tools, Add-ins" and in Access 2000, and later,
it's found under "Tools, Database Utilities".

Thank you Bruce, will give it a try.

Much appreciated.

Denis.