ACC2000: Can't Modify Statement Permissions in an Access Project

ID: Q234346

The information in this article applies to:

Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

In a Microsoft Access project, you can use the SQL Server Security Tools to modify security permissions for objects, but you cannot change permissions on any of the following statements:

CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
CREATE DEFAULT
CREATE RULE
BACKUP DATABASE
BACKUP LOG

CAUSE

Access Client/Server does not include the user interface components necessary to modify statement permissions.

RESOLUTION

If you must modify statement permissions, do one of the following:

Use SQL Server Enterprise Manager included with Microsoft SQL Server 7.0.
Use the GRANT, REVOKE, or DENY statements inside a stored procedure in your Access project.
Run GRANT, REVOKE, or DENY statements directly from OSQL.

MORE INFORMATION

For more information about the GRANT, REVOKE and DENY statements, refer to SQL Server 7.0 Books Online available for download from the following Microsoft Web site:

http://support.microsoft.com/download/support/mslfiles/sqlbol.exe

Additional query words: prb


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: June 28, 1999