Microsoft KB Archive/92671

= ACC: Error When Opening Table in Design View =

Article ID: 92671

Article Last Modified on 1/18/2007

-

APPLIES TO


 * 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

-



This article was previously published under Q92671



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
When you try to open a table in Design view, you may receive the following error message, depending on your version of Microsoft Access.

In Microsoft Access 97 and Microsoft Access version 7.0:

You can't open the table for modification.

In Microsoft Access version 2.0:

Can't switch to Datasheet view and can't return to Design view.

In Microsoft Access version 1.x:

Unable to recover from attempt to switch view. Window will be closed.

Microsoft Access then returns focus to the Database window.



MORE INFORMATION
This error message occurs only in rare situations. It is an informational message only, not a program error.

Steps to Reproduce Behavior in Microsoft Access 7.0 and 97
 Two users (User A and User B) both open the sample database Northwind.mdb, non-exclusively. Both users open the Categories table in Datasheet view. Both users simultaneously switch to Design view. User A succeeds, but User B receives the following error message:

You can't open the table for modification.

 User B tries to reopen the table in Datasheet view. The table will be opened in Design view as Read-Only without any type of message. Microsoft Access returns User B's focus to the Database window. User B will be able to make changes to the design of the table but will be unable to save them. The Save option on the File menu will be dimmed.

Steps to Reproduce Behavior in Microsoft Access version 1.x or 2.0
 Two users (User A and User B) both open the sample database NWIND.MDB, non-exclusively.</li> Both users open the Categories table in Datasheet view.</li> Both users simultaneously switch to Design view. User A succeeds, but User B receives the following error message.

In Microsoft Access version 1.x:

Table is in use, cannot lock by user '<user B's logon name>' on machine <user B's machine name>'.

In Microsoft Access version 2.0:

Can't open table 'Categories' for modification. Open it read only?

</li> User B tries to reopen the table in Datasheet view and receives the following error message:

Couldn't lock table. Table 'Categories' is exclusively locked by user '<user A's logon name>' on machine '<user A's machine name>'.

</li> User B is returned to the Database window with the following error message.

In Microsoft Access version 1.x:

Unable to recover from attempt to switch view. Window will be closed.

In Microsoft Access version 2.0:

Can't switch to Datasheet view and can't return to Design view.

</li> Microsoft Access returns User B's focus to the Database window.</li></ol>

When in Datasheet view (step 3), both users have the table open, non- exclusively. When they try to switch to Design view, they are actually closing the table and attempting to re-open it, exclusively.

In the example above, User A succeeds and User B fails. When User B then tries to reopen the table (non-exclusively) in Datasheet view, User A already has the table open exclusively.

The error message in step 5 in an informational message designed to let User B know that Microsoft Access is unable to open the table in either Datasheet or Design view.

Additional query words: you can t open the table

Keywords: kberrmsg kbinfo kbusage KB92671

-

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

© Microsoft Corporation. All rights reserved.