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:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
LINKS:
Split Database: [ Ссылка ]
Update Queries: [ Ссылка ]
Record Locks Template: [ Ссылка ]
COURSES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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.
