Access/Windows/Office365 Version Checker (1 Viewer)

isladogs

MVP / VIP
Local time
Today, 08:29
Joined
Jan 14, 2017
Messages
18,186
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:
Code:
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:
Code:
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.
Many thanks

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

Attachments

  • Access&WindowsChecker.PNG
    Access&WindowsChecker.PNG
    13 KB · Views: 729
  • AccessVersionChecker.zip
    58.9 KB · Views: 411
Last edited:

isladogs

MVP / VIP
Local time
Today, 08:29
Joined
Jan 14, 2017
Messages
18,186
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
 

Attachments

  • AccessVersionCheckerMDB.zip
    41.8 KB · Views: 415
  • AccessVersionChecker2007.zip
    47.1 KB · Views: 403

Dreamweaver

Well-known member
Local time
Today, 08:29
Joined
Nov 28, 2005
Messages
2,466
I'm on a 64 bit laptop with office 365 installed which didn't show


 

Attachments

  • 2018-12-09.png
    2018-12-09.png
    17.6 KB · Views: 601

isladogs

MVP / VIP
Local time
Today, 08:29
Joined
Jan 14, 2017
Messages
18,186
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)
Code:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines

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
 

Attachments

  • AboutAccess.PNG
    AboutAccess.PNG
    4.2 KB · Views: 611
  • CTRRegistryKey.PNG
    CTRRegistryKey.PNG
    12.5 KB · Views: 585
  • CTRRegistryKey2.PNG
    CTRRegistryKey2.PNG
    30 KB · Views: 619

Gasman

Enthusiastic Amateur
Local time
Today, 08:29
Joined
Sep 21, 2011
Messages
14,037
Reports correctly for me as well in 2007 with 32bit Win10 pro
 

isladogs

MVP / VIP
Local time
Today, 08:29
Joined
Jan 14, 2017
Messages
18,186
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
 
Last edited:

Users who are viewing this thread

Top Bottom