Microsoft KB Archive/234346

= ACC2000: Cannot Modify Statement Permissions in an Access Project =

Article ID: 234346

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q234346



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 and Microsoft SQL Server 2000.
 * 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, which is available for download from the following Microsoft Web site:

http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe

Additional query words: prb can t cannot not

Keywords: kbdownload kbprb kbclientserver KB234346

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.