[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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.
0
ruavol2
Asked:
ruavol2
4 Solutions
 
RgGray3Commented:
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 )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
 
telyni19Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Jeffrey CoachmanCommented:
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
 
ruavol2Author 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now