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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 running Access 2000 database - user level security 0
accdr 1
database is placed in a state in access 2007 1
Users in Access 2007 2
Running ms access modules as admin but logged into access as a regular user.. 2
User level security 3
Access User Login form in Access with Ristriction 0
User Level Security - Many Questions about FE/BE & no login 12

Back
Top