Share this Page URL

Lesson 28. Keeping Your Data Safe > Data Protection on Forms - Pg. 146

Keeping Your Data Safe 146 no access to the design controls. Users of an MDE file can use all your forms, tables, and so on, but they cannot view and modify them in Design view. You also cannot create new forms or reports. This is not only handy from a security standpoint, but it also makes the database more efficient, so it works smoother and quicker. You Can't Go Back! Be very sure that the database objects' structures are exactly the way you want them before you create an MDE file. If you need to modify the design of forms, reports, or tables in a database saved as an MDE file, you must open the original database, make the changes, and then save it as an MDE file again. Any data entry you've done in the original MDE file must be duplicated in the new MDE file, which can be a significant amount of work. To save a database file as an MDE file, follow these steps: 1. 2. 3. Open the database you want to save as an MDE file. Select Tools, Database Utilities, Make MDE File. The Save MDE As dialog box appears. (It's just like a regular Save As dialog box.) Enter the name you want to use for the MDE file in the File Name text box, and then click Make MDE File. To open and use an MDE file, use the same procedure you learned for opening database files in Lesson 6 (File, Open) except change the Files of Type drop-down list to MDE Files (*.mde). 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