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

ID: Q209763


The information in this article applies to:

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 '<tablename>' 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:


RESOLUTION

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


REFERENCES

For more information about problems changing the design of a table, click Microsoft Access Help on the Help menu, type "troubleshoot problems viewing data or changing objects in an Access database in a multiuser environment" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: prb locking


Keywords          : kberrmsg TblProb TblModfy 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 13, 1999