ACC: "Table Exclusively Locked" Error Switching to Form View (97513)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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 <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).
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kberrmsg kbprb kbusage KB97513 |
---|
|