Any object that can check connections?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I check how many connections have been connecting to Jet or SQL server? Appreciate for advise.
 
Christina said:
How can I check how many connections have been connecting to Jet or SQL
Click to expand...
server? Appreciate for advise.

If you have admin rights to the server, you can check the connections by
using the management console to count the open files. With JET you can also
count the connections in the LDB file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks. Actually I have a small system written for warehouse users. I want to limit the number of users that can use the application. I know consulting companies sell their application by licences or number of users. I just wonder if I can do the same (similar) or any idea on the logic.
 
Christina said:
Thanks. Actually I have a small system written for warehouse users. I
Click to expand...
want to limit the number of users that can use the application. I know
consulting companies sell their application by licences or number of users.
I just wonder if I can do the same (similar) or any idea on the logic.

Build a simple login form and a table to record and count who's logged in at
any moment. You can delete the records in the table when the user count if
less than 1 as people log out, or just delete that users record as he/she
logs out.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top