Using Database Options and Attributes to Protect Data and Objects

Abstract

Microsoft access is a flexible product that allows database users to open and view a database in many ways. It is this very same flexibility that can also put your database at risk. In this chapter, you’ll find out which of the 50 or so database options will protect or expose your database. You will also learn how to hide objects in the database window so that users who are exploring the database window are less likely to stumble on your important data and objects. In particular, you will find out: Why the Compact on Close option leaves copies of your database lying around. Where personal information is stored. Why the most recently used file list exposes the location of your databases. Why its best to turn on confirmation messages to stop inadvertent deletions and changes in your database. How you can stop people from opening your database in exclusive mode. How to hide objects in the Database window.