Get Current DB's path

[TKnight]

Does anyone know how I can reference the pathway of the database that i'm working in...

The help mentions "object.path" but to use it the object has to be a reference to a file or folder etc. is it possible to get the full pathway without using this method?
Thanks, Tom.

 

[noccy]

CurrentDb.Name

 

[ghudson]

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

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

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

HTH

 

[Mile-O]

lol

The exact same question appears on this page in this forum. Try searching beforehand.

 

[TKnight]

Thanks guy's!
Mile-O-Phile, my deepest apologies! 9 times out of 10 i search the help then the forums before posting, guess i'm going to have to make it 10/10...