return the location of an open dtabase

[DRH192]

Does anyone know how to return the location of an open dtabase, i.e. return the location of its self.

cheers

 

[JerryKlmns]

CurrentProject.Path & "\" & CurrentProject.Name = CurrentProject.FullName

 

[ddiamond]

Jerry,

Does Access 97 support the currentproject object? I get an error message when I try use it. My current work around is:
currentdb.name - returns the fullname of the database including the path. But then you have to parse it if you want just the path or just the db name.

- Dan

 

[JerryKlmns]

CurrentProject is for Access 2000 or higher

 

[PHV]

And what about CurrentDB.Name ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ddiamond]

PHV,

CurrentDB.Name is supported by Access97. That is what I am currently using. CurrentDB.Name is inferior to CurrentProject.Path because you have to write additional code to parse out the path, but this code can be easily encapsulated in a user defined function.

- Dan