Microsoft Office 2000/Visual Basic Programmer's Guide

Controlling Database Access from Data Access Pages

There are three primary concerns regarding securing access to a database from a data access page:

• Preventing unauthorized users from opening the database at all
  
  
• Controlling the level of access once a database is open
  
  
• Preventing malicious scripts from using the user's identity to access other databases

For Access databases, there is the additional concern of controlling access to the database file itself (.mdb) through the file system. All of these issues are addressed in the following sections.