|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new Expression Web |
Is Your Database Corrupt ?
Real World Microsoft Access Protection And Security
Article: Introduction to Microsoft Access Security And Passwords
MS Access features three independent types of passwords:
* Database Passwords
* Security Accounts Passwords
* Visual Basic Modules passwords
Security Accounts Passwords
The most powerful yet complex way to secure a database is to set up
user-level security. If user-level security is defined, the members of a
workgroup are recorded in user and group accounts that are stored in a
Microsoft Access workgroup information file (also known as System
Database).
Each user and group account has its own unique Access Security ID (SID)
that is created from user or group name, Personal ID and Workgroup ID.
There are also some predefined SIDs that remain the same for all the
Workgroups: 'Admin' and 'guest' accounts, and 'Guests', 'Users' groups.
Each workgroup information file contains MSysAccounts table that stores
all user and group account names, encrypted user passwords and SIDs.
Access uses SIDs to check user's permissions. Each database has MSysACEs
table (both Hidden and System, not visible by default) with
permissions information for all the objects in the database. In the table
there's a list of SID/applicable permissions pairs for each database
object. Before a user attempts any action on a database object MS Access
(or Jet Engine to be exact) scans MSysACEs table using current user SID
(and all the SIDs of user's groups) to verify permissions for the action.
Read more
In
Garry's book, you will find out how to orgainse the contents of the
workgroup file so that Password Cracker software cannot read it.
Read more on the different types
of Access passwords here
|
Purchase
the book and read more about it at the following online book stores Barnes & Noble.. Amazon USA.. Amazon Canada.. Amazon UK.. Amazon Germany. |
 Read what Peter Vogel, Editor of Smart Access had to say about the book... |
Is Your Database Secure ? Need to know more about how to protect
your database investment. Confused about Access security. Then have a
look at the book that Garry's wrote for Apress in 2003. Garry's book covers best practise security and protection for Access 97 upwards. Read more |
Related Pages On This Site
Access Unlimited - Edition 66 ~ What is happening to security in Access 2007
Samples of
Data Security and Database Passwords
Samples of Object
Protection and Other Security Measures
Microsoft
Access Passwords, Workgroups and ADO
Using The
Workgroup File Security Wizard
The Workbench includes a sample
database that manages
NT /Win 2000 User Accounts
Samples of How To Change Startup
Properties and Use Hotkeys