How can I use VBA to determine where MSACCESS.exe is stored?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would to find out how to do this under program control. This way, once the
location is determined, I can create commands that can use MSACCESS from the
command line. Any help of sample code would be appreciated.
 
Dig it out of the registry but be aware that you or your eventual
users may have more than one version of Access installed and therefore
registered.

David Aylott flogs a nifty utility named ACCVER that checks the
version of the target MDB/MDE and launches the correct version of
MSACCESS.EXE. It passes command line parameters to the executable.

HTH
 
Thanks Doug - I'll take a look at the other reference you gave in a
subsequent post.
This is a nice simple solution and I like those !

Regards,
Ken
 
Back
Top