Advice Please

[Novice1]

I have split database (front end; back end). I cannot create an exe file so I know I cant truly protect the db. What can I do to limit the number of possible users (10) without the person entering a password each time.

I have limited skills (VBA) so simple (less secure) is okay. I'm not trying to lock the db, I'm trying to limit access to the casual user.

 

[Ranman256]

You don't need an exe,can you make an .accde?
I have a tUser table, it has:
userID, Rights
A user gets a code that allows them to some places. Admin gets all rights.
When the form opens, buttons are enabled/disabled.
Data sheets are read only or edit.

 

[KenHigg]

Tracking the number of users as they log in is one thing, figuring out when they close is another...Seems I read something about concurrent users somewhere...?

 

[Novice1]

It's not users I want to limit ... it's machines. If that's not possible. Is there a way to limit no more than 10 users at one time (or whatever number is decided)?

 

[Ranman256]

Again, with the tUsers table,have the field [LoggedIn].
Those logged in would get marked true.
Count them, then allow or disallow ,based on the count.