Find Access Database Version?

[aesseal]

Does anybody know how to find what version of Access a database is written in (95, 97 etc)? I need to upgrade some 95 databases to 97 at run time using visual basic, so I need to know whether it is already in the right version or not.
The only way I have found so far is to open the database as a text file and look for 'Access95', but that's a real bodge!
Any suggestions would be gratefully accepted!

Dan

 

[Terpsfan]

Set a reference to Microsoft Data Objects 3.6 Library or the highest you can find. Then try this code.

Option Explicit

Dim db As DAO.Database

Private Sub Command1_Click()

Call GetFileVersion

End Sub
Public Sub GetFileVersion()
Dim strFileName As String
strFileName = InputBox("What is the file name&quot
Set db = OpenDatabase(strFileName)
MsgBox db.Version
End Sub

'This is how the data mappings go:
'4.0 = Access 2000
'3.51 = Access 97
'2.5 = Access 95

 

[CCLINT]

And under ADO/ Jet you can do this:

conn.Properties("Jet OLEDB:Engine Type&quot

In thread222-371417 I have listed up the Jet Engine types. [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}