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.
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RgGray3Connect With a Mentor Commented:
You can toggle the AllowEdits property of your forms

You can set it in design mode to No (false)

and in code you can change it to True if you wish to do so
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Note however that users can always get to the tables, so be aware of that. You can make it difficult to get there, of course, but it's always possible.
0
 
telyni19Connect With a Mentor Commented:
Security for a database is a very tricky thing. My recommendation is to have separate forms for viewing existing data and adding new data. The add form would have the Allow Additions property as Yes and also the Data Entry property as Yes, which would prevent editing any previously existing records.

If you have any filtering or searching fields on your viewing form, you'll need to leave the Allow Edits property as Yes there too, but set up all the data fields with their Locked property as Yes. That way they can't be changed.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Depending on your exact needs this can end up being complex.

Remember that User Level Security (Which seems like what you may need here) is gone in Access 2007 format databases.
If the DB is still in the 2003 format, you can still access ULS, though...

That being said, most Experts agree that delving into the ULS is not something that should be taken lightly.
You can twist yourself into knots relatively quickly, and even lock yourself out of your own DB accidentally...
:-O
The three Experts above can tell you more of the specifics of this than I can.

There are several links on the subject though.
None of which, most people would consider "Light reading"
http://office.microsoft.com/en-us/access-help/about-user-level-security-mdb-HP003070410.aspx
http://databases.about.com/od/tutorials/ss/usersecurity.htm

I am not sure why allowing users to sort is a bad thing...
You can always force a sort order upon opening a form/report or by sorting the recordsource itself.

If you "Lock a form after editing", then suppose a user really needs to make a change?
I presume you will need some sort of "Administrative Over-ride"?

As far as the date settings go, remember that this can be mucked up by changing the Data/Time settings in Control panel.


Finally, just a general note, remember that no security is 100% full/fool proof.
Just stopping a "Curious" user is one thing, but a determined "Hacker" will always find a way to do/get what they want.


JeffCoachman


0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Very helpful thank you.
0
 
RgGray3Commented:
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.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.