ACC: "Table Exclusively Locked" Error Switching to Form View

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q97513

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

Expand all | Collapse all

SYMPTOMS

When you try to switch a form from Design view to Form view, the attempt fails, and you receive the following message:

   Table <tablename> is exclusively locked

Back to the top

CAUSE

The form's RecordSource property refers to a table that is open in Design view.

Back to the top

RESOLUTION

To work around this behavior, do one of the following:

Close the open table.

-or-
Change the open table to Datasheet view.

-or-
Open the form before opening the table (this opens the table in Design view for read-only access).

Back to the top

APPLIES TO

Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

kberrmsg kbprb kbusage KB97513

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top