How to use VBA to Get Full Access Version/Build Numbers

[EddieN1]

When I go to the the File, Account, About Access, I find that the Version of Access I'm running is "Microsoft® Access® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 64-bit" In VBA, I can find some of these values using the command "CurrentProject.Properties.Application.". For example, if I follow this with "Version", I get the 16.0 string. If I use Build, I get the 17126 node. What can I do to get the underlined values... Version 2312 and the last node of the Build ...20132. Thanks, Eddie

[Edgar]

This one liner returns the full string:

CreateObject("Scripting.FileSystemObject").GetFileVersion(SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE")

Or you can do it in a more typical way:

Sub ShowAccessVersion()
    Dim fso As Object
    Set fso = CreateObject("Scripting.FileSystemObject")
    
    Dim getAccessPath As String
    getAccessPath = SysCmd(acSysCmdAccessDir)
    
    Dim getVersion As String
    getVersion = fso.getfileversion(getAccessPath & "MSACCESS.EXE")
    
    MsgBox getVersion
End Sub

[isladogs]

The above code will give the full build number e.g. 16.0.17304.20000.
Note that this is the value to the right of the About Access button


The value on the About Access screen is often incorrect and should be ignored


Surprisingly, the YYMM version number cannot be obtained using VBA.

My free Access/Office/Windows Version Checker add-in obtains all the above information and more:



All of the information is obtained using code - except the YYMM version number which I obtain by scraping an MS version info webpage.

[EddieN1]

Just what I need. Thanks, Eddie

[isladogs]

You're welcome.
I asked the Access team about a year ago to provide code to allow the YYMM version number to be extracted - I got a positive response at the time but so far no action

This is a quote from my web article https://www.isladogs.co.uk/sys-cmd-actions/

I have also asked that a new SysCmd value (e.g. 911) be created that will return the full Access version, build and bitness information.
For example: Access 365 32-bit Version 2310 (Build 16907.20000 Click to Run) - Beta Channel