Check MS Access

[Guest]

Perhaps a silly question. I was wondering if there is a way to check if
someone has
MS Access installed on his computer without letting my application crash
when this is not the case. ?

Marco

 

[Van T. Dinh]

Do you mean using your Access application to check whether the user has
Access software installed?

If the user doesn't have Access software, he/she can't open your Access
database application in the first place so no, you can't use your Access
database application to check whether the user has Access or not.

I guess there may be 3rd-party utilites doing something similar. It
wouldn't be too hard using VB or other languages to write a small utility to
see if Access software is installed and if it is, open your database
application.

 

[Douglas J Steele]

You should even be able to use VBScript.

While I haven't tested (since I have Access on all my machines!), I would
think that trying to instantiate Access and checking the error should work.

Dim objAccess

Set objAccess = CreateObject("Access.Application")
If Err.Number = 0 Then
MsgBox "Access Installed"
Else
MsgBox "Access Not Installed"
End If
Set objAccess = Nothing