Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you try to update a record on a form in an Access database: "This Recordset is not."


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

This article applies to a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file.

↑ Back to the top


Symptoms

When you try to update a record on a form in an Access database, you may receive the following error message:
This Recordset is not updateable.

↑ Back to the top


Cause

This issue occurs when the form is based on a query that is not updateable.

↑ Back to the top


More Information

Steps to reproduce behavior

  1. Create the following new query based on the Order Detailstable in the sample database Northwind.

    Query: qryOrders
    -------------------
    Type: Select Query
    Join: None
    Field: Quantity
    Total: Group By
    Field: UnitPrice
    Total: Group By
  2. Save the new query as the qryOrders query, and then close the query.
  3. When you have the qryOrders query selected, click AutoForm on the Insertmenu.

    Note In Access 2007, when you have the qryOrders query selected, click Forms in the Forms group on the Create tab.
  4. Try to change the unit price in any record.

    Notice that you receive the error message that is mentioned in the "Symptoms" section.

↑ Back to the top


References

For additional information about how to troubleshoot errors that may occur when you update data in Access queries and in Access forms, click the following article number to view the article in the Microsoft Knowledge Base:

328828 How to troubleshoot errors that may occur when you update data in Access queries and in Access forms

↑ Back to the top


Keywords: kboffice12yes, kbfreshness2007, kbexpertiseinter, kbtshoot, kberrmsg, kbprb, kbusage, kb

↑ Back to the top

Article Info
Article ID : 209571
Revision : 3
Created on : 4/23/2018
Published on : 4/23/2018
Exists online : False
Views : 286