Unanswered: How can I find the path to the Access application - [RESOLVED]
In VB6, i could use application.path to retrieve the working directory of the vb6.exe (or whatever the file name was). Is there a way to detect that in MS Access? On the network here, people have different names of their files (i.e. some people are using Access2k.exe while others use access.exe and msaccess.exe, etc.). Anybody know a way (like CurrentDb.Name) to detect the working directory of the current Access application (preferably without a ton of API mess)? Thanks for the help.
Last edited by jmahaffie; 02-25-05 at 15:26.
Thanks, both of you. The utility at the site RedNeckGeek sent is pretty cool, but the syscmd(acsyscmdaccessdir) that RoyVidar sent is precisely what I'm looking for. I needed that to build a shortcut for the users, since some people have their MSAccess.exe file in different directories. Thank again for the help!