Access Security Alternative Example
The standard Microsoft Access security is a cumbersome method for performing simple security tasks such as letting only certain users modify data and allowing on some users to view the data.
We have developed a simple method to implement levels of access to the data. Note that Access databases can never be totally secure and therefore should not be used for highly sensitive data.
In this MS Access downloadable database example you will find the following Access and Visual Basic programming techniques:
Use the NTLogin (username) to determine who is using the database.
Set global variables
Use the Dlookup function
See how to setup a tabbed user interface
Learn how to create a Visual Basic Module
Set properties of forms to restrict viewing, editing and deletion of data.
Try out Access Security Alternative downloadable example database.
As you probably know by now Microsoft is phasing out the standard user security controls. As you can tell, we found the security control implementation complex and fragile. Additionally, activation of the built in security system affected all Access database on our computers.
We find a simple list of user privileges combined with a tabbed user interface to be the best solution since Access database can never be made truly secure. This custom security method has been test in all version of Access including Access 2010.