Uploaded July 2026 | Updated September 2026, 2 weeks ago
In this lesson, we will troubleshoot why you can't edit data in Microsoft Access tables, forms, and queries. We will cover permissions, linked tables, record locks, form and control properties, calculated controls, query types, joins, primary keys, external data sources, VBA settings, and possible corruption. You will also learn a step-by-step workflow for isolating the feature or setting that makes a recordset read-only.
Rebecca from Cincinnati, Ohio (a Platinum Member) asks I have a customer form that has worked for months, but now I can see all the records but can't change anything. Some fields beep when I type, and a query I use for orders is read-only too. How can I figure out what is preventing Access from saving my changes?
CHAPTERS:
00:00 Introduction
02:11 Test Whether the Table Is Editable
04:03 Troubleshoot Linked Tables and Permissions
05:44 Check Form Edit Settings
07:42 Check Individual Control Properties
09:38 Identify Non-Updateable Query Types
11:13 Distinct Values and Calculated Fields
13:21 Troubleshoot Joins and Relationships
17:39 Review Table Design and Primary Keys
19:15 Check VBA Code and External Permissions
21:34 Follow the Troubleshooting Workflow
23:07 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Can't Edit: 599cd.com/CantEdit
LINKS:
Record Source: 599cd.com/RecordSource
Disallow Editing Data: 599cd.com/1203
Not Updateable: 599cd.com/1614
Outer Joins: 599cd.com/1455
Troubleshooter: 599cd.com/1193
RECOMMENDED COURSES:
Access Beginner 1: 599cd.com/ACB1
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
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access form read-only, Access query not updateable, recordset is not updateable, operation must use an updateable query, Allow Edits property, Recordset Type Snapshot, locked control, linked table permissions, editable query joins, Access primary key, DISTINCT query read-only
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will troubleshoot why you can't edit data in Microsoft Access tables, forms, and queries. We will cover permissions, linked tables, record locks, form and control properties, calculated controls, query types, joins, primary keys, external data sources, VBA settings, and possible corruption. You will also learn a step-by-step workflow for isolating the feature or setting that makes a recordset read-only.
Rebecca from Cincinnati, Ohio (a Platinum Member) asks I have a customer form that has worked for months, but now I can see all the records but can't change anything. Some fields beep when I type, and a query I use for orders is read-only too. How can I figure out what is preventing Access from saving my changes?
CHAPTERS:
00:00 Introduction
02:11 Test Whether the Table Is Editable
04:03 Troubleshoot Linked Tables and Permissions
05:44 Check Form Edit Settings
07:42 Check Individual Control Properties
09:38 Identify Non-Updateable Query Types
11:13 Distinct Values and Calculated Fields
13:21 Troubleshoot Joins and Relationships
17:39 Review Table Design and Primary Keys
19:15 Check VBA Code and External Permissions
21:34 Follow the Troubleshooting Workflow
23:07 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Can't Edit: 599cd.com/CantEdit
LINKS:
Record Source: 599cd.com/RecordSource
Disallow Editing Data: 599cd.com/1203
Not Updateable: 599cd.com/1614
Outer Joins: 599cd.com/1455
Troubleshooter: 599cd.com/1193
RECOMMENDED COURSES:
Access Beginner 1: 599cd.com/ACB1
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
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access form read-only, Access query not updateable, recordset is not updateable, operation must use an updateable query, Allow Edits property, Recordset Type Snapshot, locked control, linked table permissions, editable query joins, Access primary key, DISTINCT query read-only
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
