%dim crumb crumb="Access Security Alternative" Crumb2="Access Security Alternative Download" crumb1="Security Method for Microsoft Access" %>
Open Email Using SendObject Access Download
User Inactivity Logout VBA Code
Disable Shift Key Demo
Send Email Microsoft Access Tutorial Download (Advanced)
Programming MS Access Security Alternative
Single User Inventory Calculations Download
How To Perform Multi-User Inventory Calculations
Make Dependent Combo Box Code MS Access Tutorial
Union Query (Advanced) Access Tutorial
How To Fill Fields From Combo Box
<% gnum="6502486262" %>
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:
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.
MS Access 2003
<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>
MS Access 2013, Access 2010 & Microsoft Office 2007