[RESOLVED] Getting the Path tat MS Access is executing on

Hi,

I am using VBA in MS Access.. Are there any methods that will enable me to obtain the path that this MS Access file (mdb) is opened in?

PS : i do not mean the EXE file of MS Access..

thks..

Yes.

VB Code:

'MS Access installation path:
MsgBox Application.SysCmd(acSysCmdAccessDir)
 
'Access database path
MsgBox Application.CurrentDb.Properties(0).Value

Quote:

---

Originally Posted by RobDog888

Yes.

VB Code:

'MS Access installation path:
MsgBox Application.SysCmd(acSysCmdAccessDir)
 
'Access database path
MsgBox Application.CurrentDb.Properties(0).Value

---

thks.. it works to perfection...