Database Filepath

[Guest]

Hello,

I need to konw the filepath of my database.

The purpose is to open a text file located in the same filepath. The problem
is that the user can install the database (and the text file) anywhere in his
hard drive.

Is there a way to know the filepath of the database?

Thanks you very much,

Claude Fortier

 

[Nikos Yannacopoulos]

CurrentProject.Path will return the path.

HTH,
Nikos

 

[Paul Overway]

See CurrentProject.Path

 

[Mark M]

I'm not sure how long ago this became available, but CurrentProject.Path
will do it in recent versions of Access.

 

[Guest]

CurrentProject.Path will return the path.

Thanks to everyone, it works! I also learn how to interact with the
application directly.

It was so simple It's nearly a shame I did not find it by myself... :-|

Claude Fortier