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:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Access Connectivity Engine\Engines
For 32-bit Office on 64-bit Windows, it looks for:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines
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.
NOTE: I am also posting this at 2 other forums to get more feedback