Encoding a Database

An unauthorized user could access your data by bypassing Access entirely. Special utility programs exist that allow users to retrieve data without going through Access. You can guard yourself from this problem by encoding your database. Encoding makes the database file indecipherable to these types of programs. Be aware, however, that encoding does not prohibit someone from using Access to open and read an encoded database file.

Encode a Database

graphics/1_icon.jpg

Make sure all users close the database.

graphics/2_icon.jpg

Click the Tools menu, point to Security, and then click Encode/Decode Database.

graphics/3_icon.jpg

Locate and select the database file you want to encode.

graphics/4_icon.jpg

Specify a name and location for the encoded version of your database file.

graphics/5_icon.jpg

Click Save.

graphics/12inf09.jpg

Did You Know?

You lose performance speed when you encode a database . An encoded database will perform 10 to 15 percent slower.

You can decode a database . Open the encoded database, click the Tools menu, point to Security, click Encode/Decode Database, and then either replace the encoded file or create a new, decoded version.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net