Home  Fees/Services  Access 2010 Template  Access Tutorial  Access Download  Articles  Search  Contact  Privacy  Links

Read Version Number
Access Version Number






Visual Basic Tutorials:
Access-Google Earth
Age Calculation
Change To Proper Case
Email via Gmail #1
Send Gmail Email #2
Inactivity Logout Code
Outlook Email
Read Email Access
Email Attachment
Send Outlook Email
Running Sum
Denormalize Records
Stock Quotes
CreateQueryDef
Find Database Path
Detail-Master Update
Data Field Validation
Field Value New-Old
FindFirst
Access Version
Global Variable Parameter
Global Variables
Active Labels
Files List Box
Mail Merge
Quick Sort
Recordset Filters
Reference Form Field
Select Case
Access Transactions


Visual Basic Function Examples



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. Experts in small business management and scientific database programming.

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
    DoCmd.Quit
End If
End Sub
--------------------------------------------
Function GetVersion() As String
    GetVersion = SysCmd(acSysCmdAccessVer)
End Function

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.










Blue Claw Database Design Downloadable Tutorial:
Programming Crosstab Query Example  








A Blue Claw Software Design Template:

Work Order Administration Software
 










A Blue Claw Database Design Article:

Software Risk Assessment
 

Microsoft Office:
MS Access 2000 Through 2016 and Office 365 & Sharepoint


Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, 2010, 2013 & 2016