Get Current App Path in 97

[MPM1100]

I posted this in general question too, however...

I used to know this but have long since forgot. I need to know how to
reference the application's current path in Access 97.

Thanks in advance...
MPM

 

[Brendan Reynolds]

I posted this in general question too, however...

I used to know this but have long since forgot. I need to know how to
reference the application's current path in Access 97.

Thanks in advance...
MPM

left$(currentdb.Name,len(currentdb.Name)-len(dir(currentdb.Name)))

That includes the trailing \ so remember to trim that off if you don't want
it included.

 

[John Spencer]

Try

Currentdb().Name
to get the name of the current application.

If you want to the location of a backend (linked) table then you need
CurrentDb().TableDefs("Name of Table").Connection

You will need to parse the Connection string to get the path.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[MPM1100]

Thanks for the help!

left$(currentdb.Name,len(currentdb.Name)-len(dir(currentdb.Name)))

That includes the trailing \ so remember to trim that off if you don't want
it included.