How to programatically determine version of Access being used by users?

I have VBA to determine and log the computer's username and system name (I use it for a log on/off table).

Is there a way to determine what version of Access they are running using VBA, so I could pick that up and record it as well?
(my application is saved as an mdb (2003), but some users are using 2007)
SheaJeffAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you can use
application.Version -- will give you the  office version
11.0 for 2003
CUrrentdb.version  - will give you the Access engine version
4.0 for 2003
0
 
BarryP7Connect With a Mentor Commented:
Application.Version returns the version of Access in use (eg. XP is 10.0)
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this link
http://msdn.microsoft.com/en-us/library/bb177595.aspx


Access 2000,2002,2003 are all Version 4

Database Engine      Version (year released)      Microsoft Access
Microsoft Jet      4.0 (2000)                         2000 (9.0)
Microsoft Jet      4.0 (2002)                         2000 (10.0)
Microsoft Jet      4.0 (2003)                         2000 (11.0)
Microsoft Ace    12.0 (2007)      
0
 
tbsgadiCommented:
SysCmd(acSysCmdAccessVer)

Gary
0
 
SheaJeffAuthor Commented:
Application.Version was exactly what I needed.
Thanks also for telling me the values for the respective versions.
0
All Courses

From novice to tech pro — start learning today.