Microsoft KB Archive/98666

= ACC: Form Based on Query May Not Be Updatable =

Article ID: 98666

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 Q98666



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



SYMPTOMS
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, &quot;This Recordset is not updatable.&quot;

NOTE: In version 1.x, this behavior occurs when you set the DefaultEditing property to AllowEdits, and the message you may receive is &quot;Form is read only.&quot;



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



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 &quot;Symptoms&quot; section.

