O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required