Access/Windows/Office365 Version Checker

Attached is a simple utility for checking the following:
a) Windows version & bitness (32/64-bit)
b) Access version & bitness
c) Whether Office 365 is installed



Save this to a trusted location or click Enable Content
It will then automatically collect the info similar to that below.
It will take a couple of seconds or so to complete

I have included both a) & b) in previous uploads but c) is new.
I would appreciate feedback from forum members as to whether it correctly detects whether Office 365 is installed (or not)

Detecting Office 365 is more difficult because the same version numbering is used for both retail & subscription versions of Access
Instead the code checks for a ClickToRun registry key - if it exists, you have Office 365.

For example, it looks for this key on pure 32-bit or pure 64-bit systems:

For 32-bit Office on 64-bit Windows, it looks for:

I've successfully tested it on 4 different PCs with:
- Windows/Access both 32-bit
- Windows/Access both 64-bit
- 64-bit Windows & 32-bit Access
- dual installation of Access 2010 & Access 365 (as in the screenshot)

However, if any Access 365 users have different Access 365 registry keys than those I've listed, the code would not detect it being installed. Which is what I'm indirectly trying to check.

Once I know the Office365 part works for other people, I can use similar code to write to the registry in another utility

Please could you let me know whether or not the Office 365 check works correctly for you and which versions/bitnesses of Access/Windows you have.
Many thanks

NOTE: I am also posting this at 2 other forums to get more feedback

I've had feedback that this didn't run in A2007 - caused by the use of themes on buttons

Two new versions attached - MDB & modified ACCDB for 2007
I've now tested the MDB version in A2003 and both versions in A2007

I'm on a 64 bit laptop with office 365 installed which didn't show

Hi Mick
Thanks for the reply.
OK so you have 32-bit Office & 64-bit Windows
Please could you check 3 things for me.

1. What does your About Access menu item say (in File menu).
This is mine (using 32-bit Office & 32-bit Windows)


2. Could you search the HKEY_LOCAL_MACHINE hive in the registry for this key (or something very similar)

It should look something like this:


Do you have a SystemDB string value similar to this (as that's what I'm scanning for).
If not could you post:
a) the full registry key path for the Engines folder on your system
b) a screenshot of what you do have in the folder

Also could you open the ACE subfolder & post what you have there.
This is mine



Thanks in advance

Reports correctly for me as well in 2007 with 32bit Win10 pro

Thanks Paul

FYI:
I think I've got the definitive explanation of why some of my A2010 ACCDB apps run in 2007 but not all.
If there is a startup form containing themed buttons, you will get an 'unrecognised database format' error at startup

Possible workround which may work for you in an 'emergency'
Open using the shift key bypass if it lets you
Remove the startup form.
Now open that form in design view and replace themed buttons with ordinary buttons.

I've fixed a few problems with running apps in 2007 by:
a) converting ACCDB to MDB in A2010
b) opening MDB in 2007 & converting back to ACCDB

An updated version of this utility has been posted to the code repository
https://www.access-programmers.co.uk/forums/showthread.php?p=1603335#post1603335

This fixes issues experienced by users with 32-bit Access running in 64-bit Windows