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