Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 22Database Security

The procedures in this chapter demonstrate how to use simple Data Definition Language statements to easily manage database and user passwords, create or delete user and group accounts, and grant or delete permissions for database objects.

Setting the Database Password

Database security can be handled at share level or user level. Share-level security is the easiest to implement, as it only requires that you set a password on the database. As mentioned earlier in this book, user-level security can only be used with Access databases created in the MDB file format.

To set a new database password or change an existing password, use the ALTER DATABASE PASSWORD statement in the following format:

ALTER DATABASE PASSWORD newPassword ...