Counting the number of session's in my database

[Guest]

Hi ,
I have have a small application , with MS Excel as the front end and MS
access as back end.
Is there a way that I can get the no. of sessions / connections going on in
my database at any given point of time through VBA code.

I want to use this function in my MS Excel, which would connect to the given
database and find how many connections are there in the database at that
point of time.

Appreciate your help !!

Thanks
Shiv

 

[Chris Nebinger]

This was written for Access, but the technique is the same:

http://www.mvps.org/access/modules/mdl0055.htm


Chris Nebinger