| | |
|
|
|
Any object that can check connections? |
|---|
| message from =?Utf-8?B?Q2hyaXN0aW5h?= on 15 May 2004 |
How can I check how many connections have been connecting to Jet or SQL server? Appreciate for advise.
|
| Arvin Meyer replied to =?Utf-8?B?Q2hyaXN0aW5h?= on 16 May 2004 |
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.
|
| =?Utf-8?B?Q2hyaXN0aW5h?= replied to Arvin Meyer on 16 May 2004 |
Is it possible that I can use codes to detect or count the connections?
|
| Arvin Meyer replied to =?Utf-8?B?Q2hyaXN0aW5h?= on 16 May 2004 |
To the best of my knowledge, without permissions, you can't on a SQL-Server
box, but the best place to ask that is in a SQL-Server group
This article will help with JET:
http://www.mvps.org/access/general/gen0034.htm
|
| =?Utf-8?B?Q2hyaXN0aW5h?= replied to Arvin Meyer on 16 May 2004 |
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.
|
| Arvin Meyer replied to =?Utf-8?B?Q2hyaXN0aW5h?= on 17 May 2004 |
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.
|
| =?Utf-8?B?Q2hyaXN0aW5h?= replied to Arvin Meyer on 17 May 2004 |
Thanks. I agree this is the only way.
|
|
Archived message: Any object that can check connections? (Microsoft Access Database)
