Browse [Find a directory or file]

[aweizd]

(Referring to this post by ghudson)


Hi,

This post was very useful, it really helped me out, but I do have one question. My database will be used by multiple users and will be stored on a mapped network drive, just as the files that I want to link to. Now unfortunately not all machines are configured the same, so the same network drive can have different drive letters depending on the machine and this might cause problems. Is there a way to modify the code to get the absolute network path instead of the drive letter?

thx
Luke

 

[The_Doc_Man]

In VBA code, you can get the current database's name and path using

CurDB.Name

which gives you the fully-qualified specification of the DB file. You can parse that if you need to.