User level Access

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Hi

I have database in access 2007 where users will be logging in at different
times on the same computer.

i have created the login form and login table and thats working OK.

What i want is that, when normal users logs in

1) Navigation Pane is locked.
2) Top ribbon is locked.
3) User is not able to make any design changes to the database.
4) User will be able to only add, delete, query data.

While admin users should be able to do anything with database.

Any help will be appreciated.

Thanks
 
Deepak said:
Hi

I have database in access 2007 where users will be logging in at different
times on the same computer.

i have created the login form and login table and thats working OK.

What i want is that, when normal users logs in

1) Navigation Pane is locked.
2) Top ribbon is locked.
3) User is not able to make any design changes to the database.
4) User will be able to only add, delete, query data.

While admin users should be able to do anything with database.

Any help will be appreciated.

Thanks
Click to expand...

If you're working with an mdb file then the built-in user-level security
might be an option for you. Have a look at the links on my web site.

Keith.
www.keithwilby.co.uk
 
Back
Top