Checking Filepath of MSAccess.exe

[Ed2020]

I am having some problems with users of one of my systems taking copies of MS Access 2000 and putting them on their local drives. They are then launching my systems from this copy of Access, rather than the network copy.

I am not entirely happy about this and would like to code my systems to only work when launched with the networked MS Access.

Is there any way of checking the filepath of the Access executable that the current database is running in?

Ed Metcalfe
ed_metcalfe@hotmail.com

 

[junice]

What i can help you is to provide the following coding which gets the full path of where your database is residing...

Left$(CurrentDb.Properties(0), InStr(1, CurrentDb.Properties(0), Dir(CurrentDb.Properties(0))) - 1)

 

[Mossoft]

Try:

msgbox syscmd(acSysCmdAccessDir)

M