O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Encrypting a Database

Encryption "scrambles" the contents of a database so it's indecipherable, even by a utility program that an expert user might employ to see your database from outside of Access. If you are worried that password protection is not enough security, you might encrypt the database as well as password-protect it. You must decrypt it before you can use it again.

Only the Owner

If you are working in a shared file environment, such as a network, you may have access to files that you are not the owner of. Only the owner can encrypt a database file.

To encrypt a database, follow these steps:

  1. Close all databases. This is important; you can't encrypt a database that is open.

  2. Select Tools, Security, Encrypt/Database.

  3. In the Encrypt/Decrypt ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required