Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More Help for Setting up Access Security

Security

More Help for Setting up Access Security

by  tlbroadbent  Posted    (Edited  )
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.

[color green]Free Access Security tutorial[/color]
http://www.moretools.com/lessons/access_security.htm

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.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top