User level Access

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
 
K

Keith Wilby

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

Running ms access modules as admin but logged into access as a regular user.. 2
Users in Access 2007 2
Security - Am I missing something? 4
Problem adding group to user-level security 3
Access 2007 running Access 2000 database - user level security 0
database is placed in a state in access 2007 1
User-level security? Read-only users, and full access users. 3
User Level Security Enquiry 1

Top