How to tell what version of Access is running on PC?
Printable View
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