Version Property

           

• Microsoft Jet workspace — On the DBEngine object, returns the version of DAO currently in use. On the Database object, returns the version of Jet that created the .mdb file.
  
  
• ODBCDirect workspace — On the DBEngine object, returns the version of DAO currently in use. On the Database object, returns the version of the ODBC driver currently in use.

Return Values

The return value is a String that evaluates to a version number, formatted as follows.

• Microsoft Jet workspace represents the version number in the form "major.minor". For example, "3.0". The product version number consists of the version number (3), a period, and the release number (0).
  
  
• ODBCDirect workspace represents the DAO version number in the form "major.minor", or represents the ODBC driver version number in the form "major.minor.build". For example, the DBEngine.Version value of “3.5” indicated DAO version 3.5. A Database object's Version value of 2.50.1032 indicates that the current instance of DAO is connected to ODBC version 2.5, build 1032.

Remarks

In a Microsoft Jet workspace, the Version property of a Database object corresponds to a version of the Microsoft Jet database engine, and doesn’t necessarily match the version number of the Microsoft product with which the database engine was included. For example, the Version property of a Database object created with Microsoft Visual Basic 3.0 will be 1.1, not 3.0.

The following table shows which version of the database engine was included with various versions of Microsoft products.

Microsoft Jet Version (year released)	Microsoft Access	Microsoft Visual Basic	Microsoft Excel	Microsoft Visual C++
1.0 (1992)	1.0	N/A	N/A	N/A
1.1 (1993)	1.1	3.0	N/A	N/A
2.0 (1994)	2.0	N/A	N/A	N/A
2.5 (1995)	N/A	4.0 (16-bit)	N/A	N/A
3.0 (1995)	‘95 (7.0)	4.0 (32-bit)	‘95 (7.0)	4.x
3.5 (1996)	‘97 (8.0)	5.0	‘97 (8.0)	5.0