Detect Version

[JimS]

My users must have A2007 SP2 running in order for some of the functions in my
app to work. How do I check to see what version they're running
(programmatically) so I can warn them if they're not running the correct
version?

 

[Douglas J. Steele]

While it hasn't been updated for Access 2007 (or even Access 2003), the code
in http://www.mvps.org/access/api/api0065.htm at "The Access Web" should
work. You'll just need to determine what the values should be.

 

[Allen Browne]

msaccess.exe will be version 12.0.6423.1000.

To read this programmatically (and display on your splash screen), see:
http://allenbrowne.com/ser-53.html#MSAccess

 

[Daniel Pineault]

See if this post doesn't point you in the right direction:

http://www.microsoft.com/office/com...&p=1&tid=070bd832-03f8-47b7-98ee-1d2845452a7e

Also, you could write some code to check the file version based on the table
found at
http://labnol.blogspot.com/2005/09/determine-microsoft-office-2003.html
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.