User Permissions

[Guest]

Hello.
I'm setting up a vehicle booking database, where users will be able to book
certain vehicles for trips, etc. Is there a way I can limit what records each
user can see/edit? For example, I want to restrict what records the user sees
in the Vehicle Bookings form.
I hope this males sense. Any help would be most appreciated.
Thanks

 

[Joan Wild]

You can setup user level security to do this. Study up on security:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

If a vehicle is limited to one user, you can store the Access username with the vehicle record. Then base your Vehicle bookings form on a query which uses a criteria of CurrentUser() on the username field. This will then only retrieve the vehicles assigned to the user currently logged in.