How to determine the Access version?

[Anna Turovsky]

When you open an Access DB using DAO, with the OpenDatabase function or
method, you get a database object back. The database object has a version
property which identifies correct the database's version as an Access
database.

Unfortunately this version is not like "Access 97", "Access 2000". It is
3.0, 3.5, 4.0. (That is not the Jet's version). What is the right
translation between this number and the Access version?

 

[Allen Browne]

SysCmd(acSysCmdAccessVer)

11 = 2003
10 = 2002
9 = 2000
8 = 97

 

[Anna Turovsky]

Thanks, Allen for your answer!

So, if I get version = 3 or version = 4, what Access version does it
translate to?

 

[Douglas J. Steele]

I don't believe there was any such version. Access skipped versions 3, 4, 5
and 6 (it went from Access 2.0 to Access 7.0 aka Access 95)

 

[Anna Turovsky]

Just want to clarify.
In my question version = 3 or version = 4 are not Access 3.0 or Access 4.0.
When you open an Access DB using DAO, with the OpenDatabase function or
method, you get a database object back. The database object has a
version property which identifies the database version. The numbers 3 or 4
(actually 3.0, 4.0) are what you get using that property.
These numbers translate into Access versions. For example, 8 = Access 97, 9
= Access 2000, 10 = Access 2002...
So, what 3 and 4 translate into?

 

[Douglas J. Steele]

Despite what you said in your first post, that is the Jet version.

3.0 corresponds to Access 95, 3.5 corresponds to Access 97 and 4.0
corresponds to Access 2000, Access 2002 or Access 2003.

See http://msdn.microsoft.com/library/en-us/dao360/html/daproversion.asp