Access Version (????)

Topic

New Reply

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

Reply | Quote

Replies

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)

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

Many thanks for the information.

Tom

Reply | Quote

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

? Application.Version
‘ generated error

I usually use the SysCmd function for this purpose:

? SysCmd(acSysCmdAccessVer)
9.0

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

? SysCmd(acSysCmdAccessDir)
C:Program FilesMicrosoft OfficeOffice

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

HTH

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Tom

Reply | Quote