AddFromFile for Reference using relative file path

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a reference to an Access db. We have one copy of that db for each
user, but that copy is stored on a network drive which is mapped on each
user's machine. Can I somehow get the reference to use the relative path
rather than the absolute path to the mdb file?

A workaround is to copy the mdb to each user's local machine, but that makes
updating it a real hassle.

Thanks for the help.

Danny
 
The short answer to your question is no, you can't use a relative reference.
If you really can't move it, you'd have to put logic in that determines what
the absolute reference is and resets it as the user opens the database.
However, you really should have the database on each user's local machine.
Check what Tony Toews has at http://www.granite.ab.ca/access/autofe.htm for
how to solve the update issue.
 
Thanks for the reply Doug. I'm working on copying the file to each
workstation. We already have in place a versioning system, which works quite
well.

Ciao.

Danny
 
Back
Top