Locating MSACCESS.EXE

[WP]

In dynamically creating a shortcut for my ACCESS db. I need to locate the path of MSACCESS.EXE. <br>
<br>
Does anyone know how I might do this using VBA code? <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[culshaja]

Use API call to access the registry. The install location of office is in the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\BinDirPath<br>
Access is then in this directory.<br>
The above key assumes that the version of Office that you have is Office 97. If you have nother version then check the version key in the registry.<br>
<br>
James

 

[WP]

Never used the registry API call. But will look it up and give it a go.<br>
<br>
Many thanx<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[DougP]

need API help?<br>
Book <br>
Visual Basic Programmer's Guide to the WIN32 API<br>
By Dan Appleman<br>
Publisher= Ziff Davis<br>
ISBN 1-56276-446-2<br>