Fix the This Recordset is Not Updateable Error

In this video I'm going to explain a few reasons why you might get the "this Recordset is not updateable" or "operation must use an updateable query" error message, and show you some solutions.

Ernesto from Arlington, Texas (a Platinum Member) asks: I wanted to add a StateT table to my database so that I could have the state abbreviation and the full state's name. This way in my forms and reports I could show the full state name even though only the abbreviation is entered into my CustomerT table. Once I do that and make the join, however, I get the error message that "this Recordset is not updateable" and I can't change anything in the form or the query. What did I do wrong?

Members

We will discuss a total of 18 different ways in which your recordsets might not be updateable. See the full checklist below!

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

Relationships: https://599cd.com/Relationship
Relational Combo Box: https://599cd.com/RelationalCombo
Outer Joins: https://599cd.com/OuterJoin
Troubleshooter: https://599cd.com/Trouble

Full Checklist

• Missing Primary Key
• Aggregate Queries
• Field Locked or Disabled
• Error 3326
• Calculated Field
• Crosstab Queries (TRANSFORM)
• Database Opened Read Only
• No Permission (File, Network)
• UNION Queries
• SQL Pass-Through Queries
• Unique Values (DISTINCT)
• Cartesian Joins
• Recordset Type set to Snapshot
• Query Based on Another Read Only Query
• Database Untrusted Location
• Allow Edits, Additions
• Corrupt Database (Compact)
• Relink Your Tables

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.