Security and Access, where to start? What to do?
Security can be simple and complicated, it all depends on your needs and abilities. It can be superficial, as it can be very granular. As such, I thought I’d present a couple options to help people get going in the right direction.
What does this demo illustrate?
In the demo, I demonstrate 3 different techniques:
The Static Password Approach
- How to password protect a single command button using a hard-code VBA password
The Dynamic Automatic Authentication
This use a set of security tables that you setup once and then the database can automatically authenticate and apply security as required. Although this example demonstrates restricting access to a command button, it can be used to control access to forms, reports, …
This is by far the preferred approach and although requires a little more initial setup time, in the long run it will drastically simplify your work.
- How to restrict executing a command button’s code
- How to restrict access (visibility) of a command button
Disclaimer/Notes:
If you do not have Microsoft Access, simply download and install the freely available runtime version (this permits running MS Access databases, but not modifying their design):Microsoft Access 2010 Runtime
Microsoft Access 2013 Runtime
Microsoft Access 2016 Runtime
Microsoft 365 Access Runtime
In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.
Download a Demo Database
Feel free to download a demo copy by using the link provided below:
Download “MS Access Security_Demo Database (accdb x32)” Security_Demo.zip – Downloaded 7751 times – 56.08 KBVersion History
V1.000 (2017-07-10)
Initial release