Access Database Security Programmer

Almost anyone who uses a Microsoft Access application also uses one of the following (or all) methods to protect the database: locking, locking,

1. Protect the VBA code (Visual Basic for Application) by selecting the Properties on the menu Tools of the editor window Microsoft Visual Basic then select the page Protection on the dialog box Project Properties . Finally, select Lock project for viewing , followed by password protection. In this way, the structure and data of the tables can be viewed and modified.

2. Use the function Make MDE file to prevent code modifications, form design and report design. In this way, the structure and data of the tables can still be retrieved for transfer to another .MDB file that views and modifies.

3. Use the function Encrypt / Decrypt database ... to encrypt the database, prevent utilities or decode documents, but still use Access to open it.

4. Use the function Set database password to set the password for the database. This is a bit of a hassle if there is a table in another database that links to it. If you forgot your password ... then cry!

5. Design a startup form, which requires the given name and password, using the dialog box Startup (from the list Display Form / Page ) to open this form the first time you open the database. Thanks to this, we can hide the window Database , where you can view and select the components of the database for repair.

In the above ways, the fifth way can still be overcome by pressing and holding the key Shift while opening the database. To fix this, you can use Visual Basic to assign values False for attributes AllowBypassKey to disable the key Shift when opening the database.

Suppose you have a database named dbLock.MDB. Each time you open it, you want the form frmKhoiDong Always displayed first Display Form / Page was frmKhoiDong . To change a property AllowBypassKey , forced to open the database, set new values ​​for this property, close the database, the next time open the new squeeze. Remember, the key should not be opened people can open themselves, that is, we must have the key to open. Here is another form, such as frmChiaKhoa

Once the attribute has been changed AllowBypassKey Okay, sure the form frmKhoiDong is displayed when opening the database. So we put the key through this form by drawing a widget (as long as it has a procedure for handling the situation Click is okay), such as label lblChiaKhaa , then set the attribute Visible was and add the command line DoCmd.OpenForm "frmChiaKhoa" in case handling procedures Click . You must remember the label position lblChiaKhaa to pull out the key. Thus, the remaining problem lies in the form frmChiaKhoa

You open the Microsoft Visual Basic editor window, select the item References ... to insure Microsoft DAO xx.xx Object Library (in which, version xx.xx maybe: or 3.51 or Depending on the version of Access, of course, select the latest version) was selected in the list Available References

Figure 1 : Forms need to be designed

Figure 1 is a form frmChiaKhoa should be designed, including a text box txtPassword To receive a password that people need to unlock, type a button cmdLock Performs a database lock and a command button cmdUnlock performs database unlocking. Finished, you type the processing procedures as code 1. Before you panic on a database, you should copy the database protection to avoid locking problems but not open (because you mistype the command line) .