ACC: Open Report or Form Based on a Table Locks the Table (92687)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q92687 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
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 '<table name>' for modifications. Open it read-only?
CAUSE
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.
RESOLUTION
You must close the Form or Report window to be able to open the table in
Design view to make changes.
STATUS
This behavior is by design.
REFERENCES
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."
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kberrmsg kbprb kbusage KB92687 |
|---|
|