Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Version (????)

    I am trying to determine what version of access is running on a computer located in another state. Normally, you can left click on the HELP button and click on About Microsoft Access and determine the version running. When they left click on the help button, the only thing that appears is What's This.

    Is there anyway to get the About Microsoft Office line to appear or determine the version by another method? I think they are running Windows XP Home Edition and Access 2000.

    Tom

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Version (????)

    Any chance the mouse buttons have been switched (i.e. what happens if you click on Help with the right mouse button)?

    You can also try the following:
    - Open any database in Access (hold down the Shift key to bypass startup options) or create a blank new one.
    - Press Alt+F11 to activate the Visual Basic Editor.
    - Press Ctrl+G to activate the Immediate window.
    - Type ? Application.Version
    - Press Enter.
    - You'll see the version on the next line, where

    8.0 = Access 97
    9.0 = Access 2000
    10.0 = Access 2002 (XP)
    11.0 = Access 2003
    (12.0 = Access 2007)

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Version (????)

    On two computers in the office here, I tried typing ? Application.Version in the Immediate window and got a "Compile Error: Method or data member not found." I tried with no space between the ? and the A and with a space. Both resulted in the same error message. I carefully checked the spelling.

    We tested the mouse buttons on the computer in questions and they were not reversed. The What's This? appears on my computer when the left button is used. Other items also appear including About Microsoft Access.

    They found the installation disk so I reasonably sure, but not certain, that the version is Access 2000.

    The version is not critical at this point. We have a new user (starting in the middle of June) that I think is going to install Access 2003. I was trying to determine is we had a system which is currently running Access 2003. The literature I've read, including one of your posts, says that Access 2000 databases are compatible with Access 2003. So far I have found Access 2000 and Access 2002 that are currently running the database with no problems but no Access 2003.

    Thanks for your assistance.

    Tom

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Version (????)

    Very strange.

    Access 2000, 2002 and 2003 can all open and edit databases in Access 2000 format.
    Access 2000 cannot open databases in Access 2002/2003 format, while Access 2002 and 2003 obviously can.

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Version (????)

    It sounds like you have, in my opinion, MS's most annoying defaults set. You are not seeing the full menu.

    Right click on the menu bar and choose Customize...
    On the Options tab, uncheck the Menus show recently used commands first.
    Close

    You should now have all of the menu options available under your Help menu.

  6. #6
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Access Version (????)

    Not sure if "Application.Version" works in Access 2K??

    <code>? Application.Version</code>
    ' generated error

    I usually use the SysCmd function for this purpose:

    <code>? SysCmd(acSysCmdAccessVer)</code>
    <code>9.0</code>

    The SysCmd function can also return the directory (folder) where the running instance of MSACCESS.EXE is installed, which can also be useful:

    <code>? SysCmd(acSysCmdAccessDir)</code>
    <code>C:Program FilesMicrosoft OfficeOffice</code>

    Note: The above tested on "standard" Access 2K installation (vers. 9.0 = A2K).

    HTH

  7. #7
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Version (????)

    Many thanks for the information.

    Tom

  8. #8
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Version (????)

    Mark,

    Many thanks. Both commands worked fine on my Access 2000 system. The computer operator on the computer in question is out of town today. I will follow up tomorrow.

  9. #9
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Version (????)

    Many thanks. The computer operator is out of town. I will follow up with her tomorrow.

    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •