INF: Table Permissions Changes Not Effective with Form Open

Article ID: Q109934
Creation Date: 10-JAN-1994
Revision Date: 01-DEC-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

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

If you remove Read Data permissions from a table, the change does not take effect while you have a form based on that table open in Design view.

You receive no error or warning message when you use the Permissions dialog box to remove Read Data permissions. The open form still displays data. However the permission assignment change becomes effective as soon as you close the form.

MORE INFORMATION

Microsoft Access maintains an open connection to the table(s) the form is based on while the form is open in Design view.

The purpose of this is so that Microsoft Access does not have to reopen the tables when the form is rerun. This optimizes performance.

Make sure that reports, forms, and queries which use the table being modified are closed before you remove Read Data permissions.

Steps to Reproduce Behavior

 1. Log in as Admin and open the sample database Northwind.mdb (or
    NWIND.MDB in versions 1.x and 2.0) as shared.

 2. Add a user called User1, and then add User1 to the Users Group.

 3. Make sure that the Users Group has Read Data permissions for the
    Customers table.

 4. Minimize this instance of Microsoft Access.

 5. Open a second instance of Microsoft Access and log in as User1.

 6. Create a form based on the Customers table.

 7. Open the form in Datasheet view and view the data.

 8. Switch the form to Design view.

 9. Minimize this second instance of Microsoft Access.

Restore the first instance of Microsoft Access.

Revoke the Users Group Read Data permissions for the Customers table.

Restore the second instance of Microsoft Access. Switch the form to
    Datasheet view. Note that data is displayed even though Read Data
    permissions for the underlying table were revoked. If you close the
    form, you will not be able to reopen it because the Read Data
    permissions change has taken effect.

REFERENCES

For further information about setting a table's permissions, search the Help Index for "permissions."

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.