469,898 Members | 1,733 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

How do I find the MSAccess.exe file path??

Hello

I would like to be able to retrieve the path of the MSAccess.exe file
through code.

Using (Application.CurrentProject.BaseConnectionString) :
I can retrieve the path of the workgroup and the mdb file.

Using (Application.DBEngine.IniPath) :
I can retrieve what seems to be the Windows Registry Key path for the
Jet engine

But I can seem to find a function to retrieve the MSAccess.exe path

Does anyone know of a way?

Thanks
G.Gerard
Nov 13 '05 #1
2 18135
Try the follwing code:

Dim strPath As String

strPath = Left(CurrentDb.Name, InStrRev(CurrentDb.Name, "\"))

MsgBox "current path name to database is " & vbCrLf & _
strPath

MsgBox "current path to msaccess.exe is " & vbCrLf & _
SysCmd(acSysCmdAccessDir)

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #2
SysCmd(acSysCmdAccessDir)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"GGerard" <gg*****@nbnet.nb.ca> wrote in message
news:%F*********************@ursa-nb00s0.nbnet.nb.ca...
Hello

I would like to be able to retrieve the path of the MSAccess.exe file
through code.

Using (Application.CurrentProject.BaseConnectionString) :
I can retrieve the path of the workgroup and the mdb file.

Using (Application.DBEngine.IniPath) :
I can retrieve what seems to be the Windows Registry Key path for the
Jet engine

But I can seem to find a function to retrieve the MSAccess.exe path

Does anyone know of a way?

Thanks
G.Gerard

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by (Pete Cresswell) | last post: by
3 posts views Thread by Pedro Maria Ferro da Cunha | last post: by
3 posts views Thread by Bill Short | last post: by
11 posts views Thread by Yelena Varshal via AccessMonster.com | last post: by
3 posts views Thread by SimYing | last post: by
reply views Thread by bbrewder | last post: by
4 posts views Thread by Salad | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.