ACC: Form Based on Query May Not Be Updatable
ID: Q98666
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
You may not be able to edit a record on a form, even though the AllowEdits
property of the form is set to Yes. When you try to update data on the
form, you may receive the message, "This Recordset is not updatable."
NOTE: In version 1.x, this behavior occurs when you set the DefaultEditing
property to AllowEdits, and the message you may receive is "Form is read
only."
CAUSE
If the form is based on a query that is not updatable, you will not be
able to modify data on the form.
MORE INFORMATION
Steps to Reproduce Behavior
- Create the following new query based on the Order Details table in the
sample database Northwind.mdb (or NWIND.MDB in version 2.0 or earlier):
Query: Orders
-------------------
Type: Select Query
Join: None
Field: Quantity
Total: Group By
Field: UnitPrice
Total: Group By
NOTE: In versions 1.x and 2.0, there is a space in the Unit Price
field name.
- Run the query, and then try to change the unit price in any record. Note
that you receive one of the messages described in the "Symptoms"
section.
REFERENCES
For more information about updatable queries, search the Help Index for
"update queries," or ask the Microsoft Access 97 Office Assistant.
Keywords : kbusage FmsOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb