I have tried applying record locks to a couple forms and for some reason both users still gain access to the same form no matter what. Does the record locking need to be applied to the BE instead? What am I doing wrong? Thanks so much!
No record locking on split database (1 Viewer)
- Thread starter saip15
- Start date
boblarson
Smeghead
- Local time
- Today, 11:05
- Joined
- Jan 12, 2001
- Messages
- 32,059
The form is not locked with record locking in place. You can still use the form. Why would you want someone to not be able to use a form if someone else has that form open?
If you set the form's RECORD LOCKS to EDITED RECORD then it will keep someone else from editing the record as long as a user has that record open on their form (which can be a bad thing if they open to a record and walk away).
If you set the form's RECORD LOCKS to EDITED RECORD then it will keep someone else from editing the record as long as a user has that record open on their form (which can be a bad thing if they open to a record and walk away).
- Local time
- Today, 19:05
- Joined
- Sep 12, 2006
- Messages
- 15,709
generally, i would not use record-locking
access actually protests your data with something call optimistic record-locking, which prevents inconsistent updates anyway
in some rare cases this may present problems where oyu need to implement a different pessimistic strategy, but i would refrain form using any record locking unless you find you need it.
I never have.
access actually protests your data with something call optimistic record-locking, which prevents inconsistent updates anyway
in some rare cases this may present problems where oyu need to implement a different pessimistic strategy, but i would refrain form using any record locking unless you find you need it.
I never have.
