ACC2: No Permissions for Append Query on Secured Attached Table

 Last reviewed: April 2, 1997
Article ID: Q131814
The information in this article applies to:
  • Microsoft Access version 2.0

SUMMARY

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

If you try to run an append query on an attached table that is secure, even if you have the Run Permissions option set to Owner's, you may receive the following error message: 

   Record(s) can't be read; no Read Data permissions on '<attached_table>'
This article assumes that you are familiar with the Microsoft Access security model and with creating Microsoft Access applications using the security tools provided with Microsoft Access. For more information about Microsoft Access security, please refer to the "Building Applications" manual.

NOTE: This behavior no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

In Microsoft Access you can set the Run Permissions option to Owner's so that you can create queries on attached tables.

When you create an append query (by choosing Query, Append in the Query Design window), you have the option of choosing Current Database or Another Database. If you choose Current Database and point to a table that is actually an attached table in the current database, you receive the error described in the "Summary" section.

To avoid the error message, when you create the append query, choose the Another Database option. Select the Microsoft Access database file in which the table is local instead of the attachment.

NOTE: In the Options dialog box, you must still set the Run Permissions option to Owner's.

REFERENCES

Microsoft Access "Building Applications," version 2.0, Chapter 14, "Securing Your Application," page 335

Keywords : kbusage QryAppnd
Version : 2.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: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.