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
Microsoft AccessASP.NETSQL
Last Comment
rito1
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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