• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Keeping Your Information Secu... > Securing a Database for Distribution

Securing a Database for Distribution

When a database is used only in one office or on a local area network (LAN) or wide area network (WAN), you have considerable control over who has access to it. But if you send the database out into the world—on its own or as part of a larger application—you lose that control. There is no way you can know who is using it or what tools they might have available to hack into it. If thinking about this keeps you awake at night, you should distribute your database as a Microsoft Database Executable (MDE) file.

Suppose the owners of The Garden Company want to make a database available for use by gardening clubs in the area, but they don’t want people to be able to change its objects and perhaps “break” things. Saving a database as an MDE file compiles all modules, removes all editable source code, and compacts the destination database. Users of the MDE file can view forms and reports and update information, as well as run queries, macros, and VBA code. They cannot do the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint