ACC: Form Based on Query May Not Be Updatable

• Microsoft Access 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 form's record, even though the form's AllowEdits property is set to Yes. The message "This Recordset is not updatable" is displayed when you try to update data on the form.

NOTE: In version 1.x, this occurs when you set the DefaultEditing property to Allow Edits, and the error message displayed is "Form is read only."

CAUSE

If your form is based on a query that is non-updatable, you will not be able to modify data on the form.

MORE INFORMATION

Steps to Reproduce Behavior

1. 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 Unit Price.
   
   

2. Run the query, and then try to change the UnitPrice in any record. Note that you receive one of the messages described in the "Symptoms" section.

REFERENCES