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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
