ACC2000: Cannot Modify Statement Permissions in an Access Project (234346)


The information in this article applies to:

  • Microsoft Access 2000
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

Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbdownload KbClientServer kbprb KB234346
©2004 Microsoft Corporation. All rights reserved.