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.