faq181-83 outlines the contents of the Microsoft Access Security FAQ. The Security FAQ is an excellent document and must read if you want to setup Access Security. However, many still find Access Security intimidating. Here are some additional Access security resources that will perhaps make the job of securing Access databases slightly less difficult.
[color green]ACC2000: Microsoft Access Security Manager Add-In Available in Download Center [/color]
http://support.microsoft.com/default.aspx?kbid=235961
The security manager is installed as an Access add-in. It shows all security settings in a single view, making administration simpler and easier. It also provides ways to test and save various security settings.
The release notes for the add-in state, [color maroon] "No security administration tool can replace or be used effectively or safely without a fundamental knowledge of how Microsoft Access user-level security works."[/color]
Therefore, reading the Security FAQ is still essential to setting up security. There are other net resources that may help those who are learning Access security.
This tutorial leads the user through 12 steps of securing an Access database. It provides good narrative about the process, including the purpose, function and process of using the Access Security Wizard.
[color green]ACC: Overview of How to Secure a Microsoft Access Database
http://support.microsoft.com/default.aspx?kbid=254372[/color]
The article states, [color maroon]"This article provides an overview of how you can secure a database so that it is not changed or copied by other Microsoft Access users. This article assumes that you have a thorough understanding of the pieces that make up the Microsoft Access security model: workgroups, accounts, ownership, and permissions."[/color]
Please let me know if you have a favorite Access Security resource that should be included here.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.