Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2017
    Posts
    8

    Post How to know from which Access version (or Runtime) is the user connected to the db?

    Hi guys,



    Is is possible to know (and how) from which Access version or Access Runtime version, is the user on client workstation connected to mdb database?

    Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Bing: VBA Access Version

    https://msdn.microsoft.com/en-us/lib...ffice.11).aspx

    Application.Version
    Application.Build
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Sep 2017
    Posts
    8
    Quote Originally Posted by June7 View Post
    Bing: VBA Access Version

    https://msdn.microsoft.com/en-us/lib...ffice.11).aspx

    Application.Version
    Application.Build

    Thanks.

    Is it possible to get this info from a client workstation, not just from local FE, and also to distinguish between Access and Access Runtime?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Not sure what you mean, isn't the FE on the client workstation?

    Does Application.Name tell you what you need to know?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Join Date
    Sep 2017
    Posts
    8
    Quote Originally Posted by June7 View Post
    Not sure what you mean, isn't the FE on the client workstation?

    Does Application.Name tell you what you need to know?
    It shows Microsoft Access and its version, but do now show is it Access (as part of Office Pro) or Access Runtime (as stand-alone free installation).

    Any other ideas if you have please?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Does Runtime have the same version number as regular Access?

    No, if Application.Name returns same info for both apps, don't see any way to distinguish them.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. ms access runtime version for other computers
    By charlesgardner51 in forum Access
    Replies: 1
    Last Post: 09-09-2015, 03:27 PM
  2. Replies: 3
    Last Post: 09-09-2015, 03:11 PM
  3. Replies: 5
    Last Post: 07-07-2015, 01:35 PM
  4. Runtime version Access 2003 error 429
    By Docjsj in forum Programming
    Replies: 1
    Last Post: 06-25-2015, 08:14 AM
  5. Replies: 4
    Last Post: 05-30-2012, 07:00 AM

Tags for this Thread

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