MS Access Version

How to tell what version of Access is running on PC?

In Access go to HELP>ABOUT and it will tell you the version.

Thank you Memnoch1207, but I need my VB program to tell me what version of Access is on PC.

I think this is more like what you are looking for:

VB Code:

'Set A Reference To MS Access Object Library
'Set A Reference to MS DAO 3.6 or later
 
 
Private Sub Command1_Click()
Dim Axs As Access.Application
Set Axs = New Access.Application
Axs.OpenCurrentDatabase ("c:\codelib\codelibrary.mdb"), False
MsgBox Axs.CurrentDb.Version
End Sub
 
'Access 2.0 database will return 2.0
'Access 95 database will retrun 3.0
'Access 97 database will return 3.0
'Access 2000 database will return 4.0

XP will also return 4.0

Thank you very much Mr. bobp...this is most useful.

Mr. Memnoch1207 - I do not understand...XP is OS, correct, Access is database so I do not understand XP will also return 4.0

I think he means Acces XP (or acces 2002)


WiseGuy