ACC2000: Table Opened Exclusively Error Switching to Form View

ID: Q209601

The information in this article applies to:

Microsoft Access 2000

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

Additional query words: prb

Keywords : kberrmsg kbdta FmsOthr
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb