Microsoft KB Archive/209601

= ACC2000: Table Opened Exclusively Error Switching to Form View =

Article ID: 209601

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209601



This article applies only to a Microsoft Access database (.mdb).

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:

The table is already opened exclusively by another user, or it is open through the user interface and cannot be manipulated programmatically.



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

Additional query words: prb

Keywords: kberrmsg kbprb KB209601

-

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

© Microsoft Corporation. All rights reserved.