ACC2000: Table Opened Exclusively Error Switching to Form View (209601)


The information in this article applies to:

  • Microsoft Access 2000
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 <table name> 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).
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kberrmsg kbprb KB209601
©2004 Microsoft Corporation. All rights reserved.