Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

How do I lock out or deny permissions so that users cannot change data in tables or the tables themselves or properties say in a form in a Access database.

We want to make sure users cannot go in and edit records in the database and or change settings in a form or field. We have noticed that users are changing the orderby field and some of the date settings.
Also once an Access Form is filled and the record is complete how do you keep users from going back in and changing the records.....? What is the easiest way to do this.
ASKER CERTIFIED SOLUTION
Avatar of RgGray3
RgGray3

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

Very helpful thank you.
Avatar of RgGray3
RgGray3

You are welcome...

Note:  Taking control and keeping users from MUCKING ABOUT in the bits is a never ending battle.

All of the comments from the experts are valid...  and apply to different aspects of protecting your data.   From Database properties, to form properties.  The less you give them access to the safer you are.