troubleshooting Question

MS Access looking not accessed records

Avatar of thandel
thandel asked on
Microsoft Access
3 Comments1 Solution248 ViewsLast Modified:
We have a DB that has been in use, (and repairs are run regularly).

Later I've noticed the Access is locking orders that are not even being accessed.

We have a main entry form and users can navigate with this form either by entering an order number (unique key) Autonumber non editable, primary key indexed with no duplicates.

This has been working fine but now I see that if a new record is created or an order just one record away from each (i.e. Order 789 and 790) that one is locked while the other is being worked on even though the locked order was never touched by user.  Ex. User creates 790 after 789 was created, user exits form goes back in and enters 790 to hit that record directly 789 is locked even though he never touched or access 789.

Any ideas?  (Sorry for being wordy)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros