Results 1 to 2 of 2
  1. #1
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954

    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

    Click image for larger version. 

Name:	Access&WindowsChecker.PNG 
Views:	15 
Size:	13.0 KB 
ID:	36463

    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
    Attached Files Attached Files
    Last edited by isladogs; 12-08-2018 at 04:23 PM.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 09-10-2016, 11:55 AM
  2. reliable version for windows 7
    By smallzoo in forum Access
    Replies: 6
    Last Post: 03-10-2014, 04:50 PM
  3. Replies: 17
    Last Post: 06-06-2013, 05:52 PM
  4. Access 2010 Office365 Web Database
    By jhts in forum Access
    Replies: 9
    Last Post: 01-31-2013, 01:34 PM
  5. Detect which version of Windows is running
    By GraeagleBill in forum Programming
    Replies: 2
    Last Post: 12-31-2012, 05:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums