Access Runtime Version determining

[Catipie]

Is there a way to determine which version of Access users have installed on their machine, as some of ours have full Access and others just Runtime. For licencing purposes we need to check out who has what.
Any ideas?
Thanks

 

[JohnLowell]

You can get the Access info from using the SysCmd function.

Use the constants:
acSysCmdAccessVer (for Access version)
acSysCmdRuntime (Returns True or False if using Runtime)
acSysCmdAccessDir (the Access directory)

If you aren't sure how to use these, lookup SysCmd in the help file.

 

[Catipie]

I am familiar with these constants, but to use them I would need to open a database on each PC, yes?
Is there a way to do this without user involvement?