Microsoft KB Archive/92687

From BetaArchive Wiki
Knowledge Base

Article ID: 92687

Article Last Modified on 1/18/2007


  • 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 Q92687

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


When you try to open a table in Design view in Microsoft Access 7.0 or 97, you may receive the following error message:

You can't open the table '<tablename>' for modification.

In Microsoft Access 1.x and 2.0, you may receive the following error message:

Can't open table '' for modifications. Open it read-only?


This error message occurs when you try to open a table in Design view when the table is the record source for a form or report, and one of the following conditions is also true:

  • A report is open in Print Preview or a form is open in Form view that has the same record source or is based on a query with the same record source.
  • A form is opened in Form view first, and then switched to Design view.
  • A report is opened in Design view, then switched to Print Preview, and then switched back to Design view. (You cannot switch to Design view if you opened the report in Print Preview first.) This message does not occur when you open the form or report in Design view first (without ever switching to Form view or Print Preview), and then open the table in Design view.


You must close the Form or Report window to be able to open the table in Design view to make changes.


This behavior is by design.


For more information about this topic, search the Help Index for "editing data, multiuser environment," and then "Tips for editing database objects in a multiuser environment."

Additional query words: locking you can t open the table

Keywords: kberrmsg kbprb kbusage KB92687