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?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. We will discuss a total of 18 different ways in which your recordsets might not be updateable. See the full checklist below!
MEMBERS VIDEO:
• Why Does My Form or Qu...
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/NotUpdateable
LINKS:
Relationships: 599cd.com/Relationship
Relational Combo Box: 599cd.com/RelationalCombo
Outer Joins: 599cd.com/OuterJoin
Troubleshooter: 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: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/Consulting
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, this recordset is not updateable, operation must use an updateable query, edit data in a query, cannot enter value into blank field on one side of outer join, missing primary key, field locked or disabled, Error 3326
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Why Does My Form or Query Say "This Recordset is not updateable" in Microsoft Access?
Пікірлер: 19