What version was database created in?

[M Skabialka]

Using Access 2007 - how can I tell what version of Access a database was
created in?

 

[Tom van Stiphout]

On Wed, 12 Mar 2008 16:12:32 -0500, "M Skabialka"

Presumably the version is somewhere in the first few bytes of the MDB
file. I have never seen it documented though. Why do you need to
know?

-Tom.

 

[M Skabialka]

To see whether they need to be converted to Acccess 2007 or not.

 

[Tom van Stiphout]

On Thu, 13 Mar 2008 08:52:38 -0500, "M Skabialka"

I ran this on an older db (from within A2007) and got some interesting
results.
Sub test()
Dim db As Database
Dim doc As Document
Dim prp As Property

Set db = CurrentDb
For Each doc In db.Containers!Databases.Documents
For Each prp In doc.Properties
Debug.Print doc.Name, prp.Name, prp.Value
Next prp
Next doc
End Sub

Results included:
MSysDb AccessVersion 08.50

-Tom.