Question How many connected users

[Thevince]

Hi everybody

I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ?

Is there an easy way to know that?

Thanks

 

[gemma-the-husky]

I think the easiest way is to design a "user activity table", and allocate logins to that table.

Then you can only have as many users as you have rows in the table.

 

[Thevince]

It should be a great idea but how can I do a user activity table ? Could you be more explicit?

Thx

 

[jdraw]

Could you tell us a little about the application you have for sale?

 

[gemma-the-husky]

have a table with columns.

ActivityID, UserName

When a user logs in, find the next table row with a blank username, and allocate the user to that row. When he logs off, clear the entry. When all the rows are full, you can't accept any more logins.


Alternatively, maybe you can interrogate the .ldb / .laccdb file, but I am not sure if you can do that 100% accurately.

 

[Thevince]

I live in belgium. My clients ask me several times for an app to purchase any kinds of goods. I've googled on "access user activity" and found what I was looking for here

http://www.business.com/business-intelligence/tracking-user-activity-in-your-access-databases/

Hi