VBA - version of access

[wtina]

hi,

i really urgently need to find out a way to see what version of access database uses.
i have a list of .mdb-s which are either in access 97, 2000 or xp. in have a code that opens every .mdb and checks tabledefs, but before that i need to identify which version of access that .mdb is in.
can so help me, please!

Thanks a lot!

 

[mp9]

In VBA,

DBEngine(0)(0).Containers!Databases.Documents(1).Properties(8)

provides a quick way of determining which version of Access is running. Beware - this returns the version in a slightly strange way though, e.g. 08.50 is Access 2000, so you might have to experiment with the results to work out which version numbers equate to which releases of Access.

Hope this helps!

http://www22.brinkster.com/accessory/

 

[evalesthy]

Also see thread222-434763.

 

[wtina]

Thank you both a lot, hope it helps (-:

Regards!