Access Version Number
Version control is necessary when a shared application is utilized by many users.
Some of the users may have a lower version of Access in their computer while others may have higher versions of Access.
Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. We are kind of like Allstate Insurance - 'we have seen it before'.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
To keep users with a higher version of Access from upgrading and locking everyone with the lower version out of the application, use
the Visual Basic code below in the form main menu open command.
To retrieve access version number used to open this application with the
following VBA code.
8.0 = Access 97
9.0 = Access 2000
10.0 = Access 2002(XP)
11.0= Access 2003
Private Sub Form_Load()
If GetVersion() <> "8.0" Then
Function GetVersion() As String
GetVersion = SysCmd(acSysCmdAccessVer)
Based on the Access version number you may need to block the
user from running the database or you may need to disable features which are
only available on higher versions of Microsoft Access. The important point
of this example is that knowing the Version number of the current instance of
Access gives you the ability to avoid conflicts and errors.