Tuesday, July 29, 2014

How To Encoding a Database in Access 2003

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.