Access - Users and permissions? - Stack Overflow
Looking for:
What happened to user-level security? |
Configuring user access control and permissions | Microsoft Docs.How to Work with Security Permissions in MS Access
The question is - how secure does this need to be? A simple login screen allowing the user to select their department would be easy, and would prevent someone in Sales from accidentally messing with Maintenance data; but a user with even a bit of Access knowledge would be able to "snoop".
You can make it more difficult to snoop, but Access by itself isn't a high-security environment. Was this reply helpful? Yes No. Sorry this didn't help. Threats include any threat of suicide, violence, or harm to another.
Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Details required : characters remaining Cancel Submit. There are a number of ways to achieve this. I discuss some of them in my blog that John linked to. One way I prefer is to store the user's department in a Tempvar or parameters table. Then your form uses a query that filters for the tempvar or joins to the parameters table.
See my blog on Securing Back Ends for details. Was this reply helpful? Yes No. Sorry this didn't help. Nothing has changed in that regard. Scott's suggestion of setting Traverse folder permissions is ideal when in a corporate environment allowing users to use the db but minimizing their ability to access the be directly. Choose where you want to search below Search Search the Community. In previous versions of MS Access, using network shared drives, to access the back-end database users needed write access - read only access wasn't a sufficient level permission.
In MS Access is that still the case, or do you still need to give users write access? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
I have the same question Report abuse.
Comments
Post a Comment