rito1
asked on
Active Connection Count in Microsoft Access
Hi All,
I am creating an ASP.NET website which connects to MS Access 2007 database.
How can I find out how many active connections the database currently has?.. I want to check if my code isn't closing them.
Thanks,
Rit
I am creating an ASP.NET website which connects to MS Access 2007 database.
How can I find out how many active connections the database currently has?.. I want to check if my code isn't closing them.
Thanks,
Rit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant thank you.
When you click the button, it shows in a list (from a table) all the users connected to the current mdb.
Be *sure* you have a reference set to both Microsoft DAO 3.6 Object Library and Microsoft ActiveX Data Objects 2.8 Library
You s/b able to adapt it to your needs ...
mx
ShowUsers.zip