top of page

Access Version Checker

The first tool I present here fits extremely well with our current bug focus: The Access Version Checker by Colin Riddington.

What are the first and most important questions to ask any poster on forums, any bug-reporting colleague or customer so you can get the case classified?


Which versions and builds of Windows and Access do you use?

Which bitness?

Which update channel?


And then the search for this information begins, which takes some time or is eternally unsuccessful for inexperienced users because it is spread over a number of places and in part difficult to obtain.


Colin's free version checker tool offers a remedy here. Download the ACCDE, remove macro blocking from the download and put it in a Trusted Location or click Enable Content and run it. The result can be seen in the screenshot:


All important information gathered in a single form and easy to pass on via the clipboard or a text file.


It couldn't be simpler, even if Colin had to fight hard behind the scenes of the ACCDE to elicit the secrets of all the version combinations from the many different systems, because Microsoft hardly offers any direct options for this.


So get the tool! It's especially useful in the context of bug reports.


BTW Colin had demonstrated the tool in my Access News in October, albeit in the add-in variant. I have since persuaded him to update the simpler ACCDE variant with all version detection features. I believe this variant will be more widely used.

937 views5 comments

Recent Posts

See All

5 Comments


Colin Riddington
Colin Riddington
Dec 23, 2022

I've just updated this utility to fix an issue with MSI installations of A2016. I very much hope that was the last remaining issue but I'm sure people will let me know if not! The latest standalone version is v2.73 and the add-in version is v2.74 Happy Xmas to one & all

Like

Ben Sacheri
Ben Sacheri
Dec 22, 2022

Would Colin consider making the source code of this available so I can add it directly inside my applications? Asking a user to locate and run a separate ACCDE adds complexity to gathering this information. I'd prefer if I could include it in my application.

Like
Colin Riddington
Colin Riddington
Dec 22, 2022
Replying to

Hi Ben

In principle I don't have an objection. It would return a favour from code you provided with your available connections utility (now also available as an add-in)


The previous version of my version checker released in 2021 was indeed available as an ACCDB/MDB file.


However, the additional functionality I have since added, made the code much more complex, partly due to the numerous 'exceptions' I had to handle to get it to work in Windows XP/7/8/10/11 and in all versions from 2000 through to 365.


As Karl mentioned, it is quite likely that MS will change the rules again for Win 12 & Access 2024 so I'm now playing safe by locking down the code.


There is currently…


Like

Colin Riddington
Colin Riddington
Dec 20, 2022

Thanks Karl. I do hope this article helps this tool to get wider exposure.

I'll let you know whether the standalone or add-in versions are more popular 😁

Like
bottom of page