limiting the records in access 2007 or 2010 to 10 users

[RuralGuy]

Just fyi: this will work as long the table is cleared before the start of the day.

I think Princess needs the *total users enroled* over the lifetime so clearing the table is not needed.

 

[vbaInet]

I think Princess needs the *total users enroled* over the lifetime so clearing the table is not needed.

I see. Yep, you're right.

 

[RuralGuy]

It took this dense brain a while to understand.

 

[vbaInet]

You can just blame it on the amount of turkeys you consumed

 

[princess_kay]

thanks i will check it out

 

[RuralGuy]

You can just blame it on the amount of turkeys you consumed

I did!

 

[DCrake]

This is a sample database that shows you how many people who are logged into a database you could use this as a counter.

Link