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

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

SYMPTOMS

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

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 

CAUSE

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

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).

Keywords : kberrmsg kbusage FmsOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb