Discover Microsoft Access Version

[paulscherm]

I have a database designed in Access 2003. I plan to distribute it to others with Access 2010 or 2007. Want to run code to hide navigation pane and ribbon (have that already). What I need is vba code that can determine what version when database is opened so I can run the hide ribbon and nav pane code. ie: If version is 2007 or 2010 then...

Any help would be appreciated. Have a wonderful Labor Day.

 

[MarkK]

Check out the Version property of the Application object. . .

Sub Test1894691348
   MsgBox Version
End Sub

 

[paulscherm]

Thanks, that works...

 

[gemma-the-husky]

note that STRICTLY, version is a string, not a number.

so eg, A2003 is version "11"