MDB File Version - NOT Access Version

B

Bob Flenniken

I am NOT looking for how to get the version of Access that
is running. I know how to do that. I am looking for the
version of Access that CREATED the .mdb file.

When I use this code:

Set db = CurrentDB()
strProgramVersion = db.Properties("AccessVersion")
msgbox strProgramVersion

I get

07.53 for an Access 97 mdb file (version 8)
08.50 for an Access 2000 mdb file (version 9)
09.50 for an Access 2002 mdb file (version 10)

How do these mdb file Access Versions relate to the
version of Access in which they were created? It looks
like 1 less than the integer value of the first two
characters. Is this a rule I can count on?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Shortcuts in OneDrive 0
Access MDB Version 3
Name of file opened, being viewed 2
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Solved Disk Full error message when exporting PDF 0
Active Content in this file is blocked issue 1
Working outlook via vba code with xlsx - error 0

Top