troubleshooting Question

Preventing users from modifying a record that's being viewed in a bound form

Avatar of Juan Ocasio
Juan OcasioFlag for United States of America asked on
DatabasesMicrosoft Access
13 Comments2 Solutions95 ViewsLast Modified:
Hello all:

I am trying to remedy a situation where users can access the same record on a bound form.  Basically I have a form with a sub form (so a header and detail table).  On the form a user can create a new record (clicking a button).  This generates a new id and also creates a new record in the database.  Likewise, the user can use a drop down on the form to select an existing record.  What I would like is for when a user is on a record (either a newly created one or an existing on they recently selected), if another user tries to access that record, via the drop down, they will get be told that record is locked.  I tried to set the Record Locks property to edited record, but this doesn't seem to work.

Any help would be greatly appreciated.


Join our community to see this answer!
Unlock 2 Answers and 13 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 2 Answers and 13 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