find the filepath of my database (1 Viewer)

[Jacob Mathai]

When I am running an ACCESS database, how can I programatically find the path of the file (data base)?
Any help will be appreciated.

 

[The_Doc_Man]

You can get the full file specification in VBA code using

Dim stDBName as String

stDBName =CurrentDB.Name

 

[ghudson]

If you want the path to the current database, then use:
Left(CurrentDb.Name,Len(CurrentDb.Name)-Len(Dir(CurrentDb.Name)))

If you want just the name of the current database, then use:
Dir(CurrentDb.Name)

If you want the path and the name of the current database, then use:
CurrentDb.Name

HTH

 

[Jacob Mathai]

Thanks my friends.