How can I modify the system database in access?

[Guest]

When I'm work on my laptop at home I work to my C drive. You have to know it
is a company laptop, I don't have rights to set anything on it. I can save
and delete only from a special folder. So when I save my database it is write
to some system files the path how can I reach the other related databases,
these are point to the C drive. When I go to the office and send the database
to someone who can work only to his or her H drive (this is a home drive for
the user) he or she could not open the database because the access is search
the related files on the C drive not on the H. I hope someone can help me.

 

[Guest]

Sorry I forget it> It is Access97

 

[Douglas J. Steele]

Use the Linked Table Manager (it's under Tools | Add-ins on the menu bar in
Access 97), or take a look at the code in
http://www.mvps.org/access/tables/tbl0009.htm for how to code your own
equivalent.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Sorry I forget it> It is Access97

me.

 

[Guest]

You might also want to try using the Linked table manager to point your
databases at a UNC instead of a drive letter assignment.
(UNC=\\servername\directory\subdirectory\ect\ect......)