Microsoft® Office Access 2003 Step by Step

Key Points

• Your goal as a database developer is to provide adequate protection without imposing unnecessary restrictions on the people who should have access to your database. The type of security required to protect a database depends on how many people are using it and where it is stored.

• You can encrypt a database, which does not prevent it from being opened and viewed in Access, but does keep people who don’t have a copy of Access from reading or making sense of the data.

• You can assign a password to your database, preventing unauthorized users from opening it.

• You can share a database on a local area network (LAN) and limit what users can do with the database by using the same network security you use to protect other information on the network. ...