File Path Name

[Guest]

It's been awhile, but is there a way to find the path name for an Access MDB
app?

Problem:
I have an app that tracks items. Each item has data and pics that appear on
a form. The app is stored in a directory "A" and the pics are stored in
"A\Pics". The form is working (showing different pics per Item) and now I
need to move it to the network.

How can i programmatically change the app path, depending if I move my app
to my local drive, network or take it home, and avoid hard coding it?

 

[Guest]

the path would be:

TheMDBPath = CurrentProject.Path
ThePIXPath = CurrentProject.Path & "\Pics\"

 

[Guest]

That will not work if the data is in a back end database. It returns the
front end path.