Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Table Opened Exclusively Error Switching to Form View

ACC2000: Table Opened Exclusively Error Switching to Form View

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ Back to the top

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

↑ Back to the top

Keywords: KB209601, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 209601
Revision : 2
Created on : 6/28/2004
Published on : 6/28/2004
Exists online : False
Views : 281