Connecting Tech Pros Worldwide Forums | Help | Site Map

How to detect MS Access version in VB?

Newbie
 
Join Date: Jul 2009
Posts: 13
#1: Jul 11 '09
Is there any way VB can detect the current version of ms access ruining in the system, and return a message that will say (YOUR MS ACCESS VERSION IS then the version).


thanks a lot for helping once again.

ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,216
#2: Jul 11 '09

re: How to detect MS Access version in VB?


Quote:

Originally Posted by mjworks2009 View Post

Is there any way VB can detect the current version of ms access ruining in the system, and return a message that will say (YOUR MS ACCESS VERSION IS then the version).


thanks a lot for helping once again.

Pick one:
Expand|Select|Wrap|Line Numbers
  1. Dim varRet As Variant
  2.  
  3. varRet = SysCmd(acSysCmdAccessVer)
  4.  
  5. MsgBox "Your MS Access Version is " & Application.Version
  6. MsgBox "Your MS Access Version is " & varRet
Newbie
 
Join Date: Jul 2009
Posts: 13
#3: Jul 12 '09

re: How to detect MS Access version in VB?


Hey.. thanks for the reaply.

It did work well.

Blessings.
Reply