i have a database with the usual user-level security enabled.
When you open the database it take you to a form and via buttons opens another form then another and so on until the user has got to their required section.
I have to groups of users who will both update the same table via different forms. Because of this i have to give both groups access to the table but i have tried to restrict access to each of the forms.
It doesn't appear to be working, you can still open the other groups form and change their data and so forth.