Optimizing Performance with an MDE File

If you share your modules with others, you may want to convert the database file to MDE format. In creating an MDE file, Access removes the editable source code and then compacts the database. Your VBA programs will continue to run, but others cannot view or edit them. There are several advantages to converting a database to MDE format. In MDE format, a database is smaller, and its performance will improve as it optimizes memory usage. Note, however, that you should create an MDE file only after the original database has been thoroughly tested .

Make an MDE File

graphics/1_icon.jpg

Close your database.

graphics/2_icon.jpg

In the Access program window, click the Tools menu, point to Database Utilities, and then click Make MDE File.

graphics/3_icon.jpg

Locate and select the database you want to convert to MDE format.

graphics/4_icon.jpg

Click Make MDE.

graphics/5_icon.jpg

Specify a location.

graphics/6_icon.jpg

Enter a name for the MDE file.

graphics/7_icon.jpg

Click Save.

graphics/14inf13.jpg

Did You Know?

You can save the original database . Make a backup copy of the original database. You'll need it if you have to edit your VBA modules or add new ones.




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