What is the function that will return the current path of the database 3

[maupiti]

What is the function that will return the current path of the database that you are working on such as
my_database.mdb

The function CurDir will only return the path that was set in tools --> Options --> General TAB, not the path of the database that is currently opened.

MyPath = CurDir

 

[src23]

Try with CurrentProject.Path

 

[RoyVidar]

For 97+
[tt]currentdb.name[/tt]

for 2000+
[tt]currentproject.fullname[/tt]

to only get the path, not the db name
[tt]currentprjoject.path[/tt]

To get only the path for the currentdb..., you'll need to strip of the string after the last "\".

Roy-Vidar