How do you get the long file name path to a db

[shar]

When I use the Currentdb.name, I get the 8.3 naming system, i.e.: C:\PROGRA~1\Projects.mdb. How can I get the long file name such as: C:\Program Files\Projects.mdb?

I am using Access 97.

Thanks.
Shar

 

[Mikeauz]

Shar,

CurrentProject.FullName works in Access 2000, no idea if it works in Access 97 though. give it a go

 

[shar]

Mikeauz,

Thanks for the reply, but it doesn't work in 97

 

[Mikeauz]

Ok sorry not to be more help.

The only other helpful thing I can thing of is 'curdir' to get the full directory name (Again no idea if it only works in Access 2000)

 

[shar]

Mikeauz,

Tried CurDir too. Seems like it gives the "Default Database Directory" setting. In my case, I set this value when users start the db. And when they have moved the db, the setting still points to where it was set in the code. Looks like Access 97 has this short coming. Thanks for your inputs.

Shar.