Microsoft KB Archive/209763

= ACC2000: Open Report or Form Based on a Table Locks the Table =

Article ID: 209763

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209763



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you try to open a table in Design view in Microsoft Access, you may receive the following error message:

You can't open the table ' ' for modification.



CAUSE
This error message occurs when you try to open a table in Design view when the table is the record source for a form or a report, and one of the following conditions is also true:


 * A report is open in Print Preview or a form is open in Form view that has the same record source or is based on a query with the same record source.
 * A form is opened in Form view first, and then switched to Design view.



RESOLUTION
You must close the Form or Report window to be able to open the table in Design view to make changes.

