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

ID: Q234346


The information in this article applies to:

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:


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:


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