Server location of Access Database

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
 
P

Paul Hammond

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
 
L

Luvin lunch

Hi Paul,

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

LL
 
Top