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
The form's RecordSource property refers to a table that is open in Design
view.
Back to the top
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