How to find the path where access application is running 1

[ajaygulati]

I need to find out the path of access application running in on the event like click of button.

Let me know if this is feasible and there is some way to find the path.

 

[RoyVidar]

Hi!

Having a textbox on a form, for instance called txtPath, use one of the following lines in the on click event of the button (I'm not quite sure if you want the access path or the db path - so some samples;-))

[tt]me!txtPath=syscmd(acsyscmdaccessdir)[/tt]

to retrieve the path where access.exe resides or

[tt]me!txtPath=currentproject.path[/tt]

to retrieve the path of where the current db resides in access 2000+ versions

[tt]me!txtPath=currentdb.name[/tt]

to retrieve path and name where the current db resides in access 97

HTH Roy-Vidar