Microsoft KB Archive/97513

= ACC: &quot;Table Exclusively Locked&quot; Error Switching to Form View =

Article ID: 97513

Article Last Modified on 1/18/2007

-

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

-



This article was previously published under Q97513



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



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

  Table 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 kbprb kbusage KB97513

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.