Get Current App Path in 97

  • Thread starter Thread starter MPM1100
  • Start date Start date
M

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
 
MPM1100 said:
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
Click to expand...


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.
 
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
'====================================================
 
Thanks for the help!

Brendan Reynolds said:
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.
Click to expand...
 
Back
Top