Real World Microsoft Access Database Protection and Security
As you might expect, there is never enough information when it comes to powerful products like Access. To assist you with further investigations, I have put together a Web page with links to Web sites and articles on the issues relating to the material in this chapter. The first three of these links discuss issues relating to the developer workgroup strategy.
-
A paper by Microsoft on securing your database without asking the user to log on.
-
The highly referenced Access security FAQ paper.
-
Mary Chipman's article in Access/VB SQL Advisor, "Is Database Security an Oxymoron?"
The remainder of the reading is related Microsoft documentation.
-
A useful paper on many aspects of Access security by Frank Rice, this book's technical editor.
-
How to use ADO with Visual Basic or VBA code with databases that are protected by Access passwords and workgroups.
-
Find all the specifics about owners , groups, SIDs, and the Admins group .
-
A short but definitive article by Microsoft on how to secure a database, including permissions for newly created objects.
-
Workgroup security explained in detail by Microsoft.
-
How to upgrade DAO to ADO, containing a lot of detail about what library to use for what security aspect.
-
Programming user security with VBA code.
-
A Microsoft article on the "No permission to convert database" message, which contains insight into some upgrade protection ideas I detailed in this chapter.
-
Database security and replicated databases.
-
More details on the Admin account, the Admins group, and the Users group.
You can find the further reading Web page for this chapter in the Downloads section of the Apress Web site ( http://www.apress.com ) or at http://www.vb123.com/ map/adm.htm .
Apart from those online links, you can review the Access security in the Contents section of the Access help file. In Access 97, look for "Securing a Database," and in Access 2000 or later, look for "Administering and Securing an Access File," as shown in Figure 8-25.
Finally, to find out about the different types of permissions for the different types of objects, search on "permissions" in Access help.