Server location of Access Database

  • Thread starter Thread starter Luvin lunch
  • Start date Start date
L

Luvin lunch

Hi,

I have an access database that sits on one of our servers and is
accessed via a shortcut on the user's desktop. The database isn't
split.

I need the database to check its own location and give me a full path
to itself. I tried using the file scripting object but it returns the
path on the local machine that is set in the database's default
database folder.

Is there any way to find out what the server location of the database
is rather than the default database folder?

I'd be grateful for any help,

LL
 
Try Application.CurrentProject.Path in VBA.

i.e.
Function Test1()
MsgBox Application.CurrentProject.Path
End Function


This will return the full path of the database.

Paul Hammond
Richmond, VA
 
Hi Paul,

That was so simple. Somewhat embarrassed to have spent as long on it
as I had. Thanks a million.

LL
 
Back
Top