ACC: "No permissions for '<table name>'" Error Modifying Table

Last reviewed: May 7, 1997
Article ID: Q92667
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SUMMARY

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you try to modify data in a table in Datasheet view, you may receive the following error message

    No permissions for '<table name>'

even though you were able to open the table without receiving any error messages.

NOTE: This behavior no longer occurs in Microsoft Access for Windows 95.

MORE INFORMATION

This error message indicates that you have only Read Definitions (in Microsoft Access version 1.x) or Read Design (in Microsoft Access version 2.0) permissions on the table. Because you have permission to view the data by default, you do not receive an error message when you first open the table in Datasheet view.

When you try to open the table in Design view, you receive the following error message:

    You don't have permission to modify '<table name>'.
    Open as read-only?

This message appears because you have no security permissions to open the table in Design view.

REFERENCES

For more information about permissions, search for "permissions command" using the Microsoft Access Help menu.


Keywords : kberrmsg kbusage ScrtOthr
Version : 1.0 1.1 2.0 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.