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

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

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

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

•	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

kberrmsg kbprb kbusage KB97513

Need More Help?
Contact a Support professional by Email, Online or Phone.
Customer Service
For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
Newsgroups
Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.