Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Record Locks    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
User editing record for hours
Julia Johnson 
    
4 years ago
Is there a best practice to handle users who edit a record, then leave the record open in the database (and thus uncommitted) for hours?

Forcing users to quickly commit to changes (or commit changes quickly) [thus unlocking the record for other potential record editors] is my goal.

I've had this issue for years but plan to implement a fix in the new databases I'm developing.

Ideas I've thought of are:
-Auto-save record every 5 or 10 secs via timer.
-Only allow changes via an unbound form. Record changes are only committed when user clicks 'Save/Close'.

Is there a better solution I haven't considered? (Database is split & BE is on our server.)
Adam Schwanz  @Reply  
           
4 years ago
Have you seen Access Record Locks Template? I use a modified version of this on my main database to see who has a record locked, you could also program in the auto-save, you could also have a force save (I have this to press alongside a force shutdown). Basically a table with yes/no that a timer event is checking for, when I push a button it turns to yes, users access sees that it needs to save and shutdown for an update, will warn the user it's happening and then it saves and closes.
Scott Axton  @Reply  
        
4 years ago

Send in the goons with baseball bats?  Waterboarding?  How about pulling out their fingernails with pliers?

LOL
It seems like there is always "THAT" worker that can't keep focused.  I agree it is a dilemma.  Unfortunately there isn't a "one size fits all" solution.

First it seems that it is a Personnel / HR / Manager issue.  Those people / persons need counseling on the importance of leaving a record open and locked.  Interrupting others work, possible corruption of records, whatever.
  
Next, you have to decide whether to save a partial record or discard it.  Maybe if said people have to redo work they have already done they will start finishing what they started.  Richard says that no data is better than bad data so you have to decide what is complete enough to save vs not enough to worry about so discard it.

My problem has been it is usually my manager that is the guilty party.  They get on the phone and get distracted and before you know it...

You could always set up an inactivity Reminder Popup with Playing Sound.
Then again what if they leave their desk and leave the record open and computer unattended?

Lots of things to think about, but truly, only you can decide what the proper method is.  
Either way I would Track Log On AND possibly Track Changes to document the issue for escalation of the issue.  It would also give you a method of recovering critical data that you didn't save.
Kevin Yip  @Reply  
     
4 years ago
In my old job I used unbound forms.  If you must use bound forms, I would use a form's Timer event to set a time limit, after which the code below would run to undo unsaved changes:

Me.Undo

Another thing to consider is whether this kind of thing could be prevented at the business end of things.  For instance, data entry can be restricted to certain users, at certain hours, things of that nature.  A company's business rules and policies would decide those.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Record Locks.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 7:39:21 AM. PLT: 0s