User permissions for forms

B

bzeyger

I have an acess DB with many user forms. I am using the user permissions
provided with Access. I have Access automaticly ask for a log in. I have a
Security file (System.mdb) Is there an easy way to set User Permissions for
each form.

I currently have 3 levels of users (Admin, PowerUser, User)

I want Admins to Have full acess
PowerUser to have acess to view all and change all
User to View info but no changing rights

I am new to Access DB and would like an easy way to do this. Can this be
automated? Can this be performed without using code? How can I do this?

Thanks for your time
 
N

NetworkTrade

yes up in the menu/tool bar are database tools / security ; one can define
permission to an object for a category of user. an object is a form, table,
query, report....it does not require coding.
 

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

Crating User Form to Add Names 1
Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Microsoft 365 Activations, Users or Devices? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Acess 2007 User Groups 3
Office365 Outlook for work email change signature how ? 0

Top