Hi Kara,
It sounds like you have a split database, and you are trying to move what is
commonly called the "back-end" (BE) database that is located on a file
server. Is this correct? If so, you need to use the Linked Table Manager in
your "front-end" (FE) application. This is the copy that you normally open to
use the database. Try holding down the shift key while opening your FE
application. If the developer has not disabled the shift key, you should see
the database window instead of a startup form. To verify that you opened the
FE, and not the BE, click on the Tables tab. The table names should include a
small black arrow. If so, click on Tools > Database Utilities > Linked Table
Manager. Place a check mark in the box that reads "Always prompt for new
location", and select the appropriate linked tables (Select All button if
they are all in the same BE database). When you click on the OK button, a
file dialog will open. You can browse to the folder that contains your BE
database, and select it.
If your BE database is on a file server, instead of your local hard drive,
then I recommend either entering the UNC (Uniform Naming Convention) path
directly, or browsing first to My Network Places, and from there to your BE
database. A UNC path looks like this:
\\Server\Share
UNC paths avoid the problems associated with mapped drive letters.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
I am using Access 2000 and I need to change the name of the folder(s) where
the database data is currently stored and get Access to recognize the new
location(s). Is this even possible?
