Experts Exchange connects you with the people and services you need so you can get back to work.

Checking MS Access instance ??

Hi !
May I know how to check whether any MS Access in running background on Win95 as well as winnt using WINAPI ??
I'd tried using "Findwindow" but it always return 0.
Any idea ??

Rukawa

Asked: 1999-01-10

Advertise Here

Visual Basic Classic

1 Solution

LVL 4

chabaudCommented: 1999-01-11

for 50 points try this code:

Option Explicit

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As Long) As Long

Private Sub Command1_Click()

If FindWindow("OMain", 0) Then
MsgBox "Access is running"
Else
MsgBox "Access is not running"
End If

End Sub

RukawaAuthor Commented: 1999-01-11

Hi !
Thanks for you answer, I'd actually tried out above code on my machine(win95) as well as nt workstation 4.0.
It doesn't work. The findwindow API always return me "0".
I'd tried out on MSVC++ as well and its works to detect MSAccess.

RukawaAuthor Commented: 1999-01-11

Hi !
Thanks for you answer, I'd actually tried out above code on my machine(win95) as well as nt workstation 4.0.
It doesn't work. The findwindow API always return me "0".

LVL 3

SendohCommented: 1999-01-11

Rukawa :
Try compile this working MSVC++ functions as another DLL and it should work. I'd experienced this before !! ^_^

LVL 4

chabaudCommented: 1999-01-11

I hope you have try my proposed code (with the custom "declare").

It works fine for me (win95 / vb6)

RukawaAuthor Commented: 1999-01-11

Hi chabaud.
I did tried (Win95/VB5.0). But don't know what are the reason its doesn't work.
Since this is urgent to me and Sendoh's answer works. So I'd decide to give him/her the points !!

Thanks for you answer anyway !!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Checking MS Access instance ??

Join & Write a Comment Already a member? Login.

Featured Post