Check MS Access

M

Marco

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
 
V

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.
 
D

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
 
Top