When people are using a form on my Access 2003 database, they will press a button to activate the record (basicly go into edit mode), when they have finished the record is de-activated.
I could do with some help on this as I want to minimise calls / updates to the back-end table. The way that I have previously done it is via putting a tick into a field on the back-end (through an update query) and then refreshing the form, to take this into account (so no future write conflicts occur).
Ideally, I would like to reliably stop other users from going onto the same record and activating it, whilst it is being updated.
Thank you
Start Free Trial
