O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Security with SQL Server/MSDE

The SQL Server/MSDE security system protects all tables, views, stored procedures, and other elements. SQL Server/MSDE has a two-tier security system that can grant or revoke very specific access rights.

As a user who grants permissions, you must have the permissions required to do so. A system administrator usually performs these tasks for larger SQL Server/MSDE installations, and regular users cannot edit the security settings.

You can fully use the options described next only if you have administrator privileges, such as, for example, the SQL Server/MSDE login name sa or membership in the system administrator server role.

Changes in Access 2002

In Access 2002 you can no longer administer users, access rights, ...

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