Record Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access.

Learn how to enable record-level locking to prevent two users from modifying the same customer record at the same time in Microsoft Access.

Rosa from Toledo, Ohio (a Gold Member) asks: I have a small office with about 15 employees using my database. Everything works great, however once in a while two users attempt to edit the same customer record and one of them gets an error message saying they can't save their changes. This costs us a lot of time and productivity. Is there any way to prevent that?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create their own custom record locking which is more flexible, allows for clearer error messages, and will warn you before attempting to run action queries that may effect locked records.

MEMBERS VIDEO:
https://youtu.be/mBQ4o9sLvaY

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/RecordLocks

LINKS:
Split Database: https://599cd.com/Split
Update Queries: https://599cd.com/UpdateQuery
Record Locks Template: https://599cd.com/RecordLocksTemplate

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, record locks, record locking, lock record, locked record, RecordLocks, lock files, record-locking, locking a record, record-level locking, write conflict, page-level locking, dirty records, no no symbol, locked symbol, this record has been changed by another user since you started editing it, drop changes, copy to clipboard, Access options, client settings, default record locking

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Видео Record Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access. канала Computer Learning Zone