Share this Page URL

Chapter 19. Implementing Security > Encoding Your Database and Saving It as an ... - Pg. 669

Implementing Security 2. 669 Click Tools, Security, Encode/Decode Database. Access will display a File Save dialog box, as shown here: 3. Browse to the location where you want to save the file, and, in the File Name box, enter HelloWorld_encode.mdb; then click Save. Access will then encode the database and reopen it for you. To decode a database, follow the same procedure. Access will detect whether your database is encoded or decoded and per- form the appropriate action. If you don't have the proper permissions to encode or decode, you'll see the following message: Another fortification procedure is saving your database as an .mde file. Saving your database as an .mde file compiles any VBA code (meaning that Access will convert the Visual Basic code from a syntax that computer programmers use and understand to syntax that only programs like Access understand). It will also remove any program code that could be modified by a user and compacts the database. The .mde file then essentially protects any VBA code in your database against mod- ification or theft. Your database will continue to operate just as it did when it was an .mdb file. To save your database as an .mde file, follow these steps. 1. 2. 3. Open the HelloWorld19_a.mdb database, located in the Chapter 19 folder where you copied the sample files for this book. Click Tools, Database Utilities, Make MDE File. Access will prompt you for a location to which to save the file. After you've chosen a location for your MDE file, click Save.