Hi all,
Unsure if this was the correct place to post this but here goes...
Essentially, I'm using an Access frontend to SQL server backend. I'm wanting to make it so that if I open record 2301 for example, and Joe Bloggs also opens this record, only I can edit it. I've been playing with SQL server locking but to no avail. Forms are currently bound to SQL views with update triggers. (Took over a pre-existing project and am ironing out a few issues currently existing in the system).
I've tried XLOCK, ROWLOCK to no avail.
Any ideas?
Unsure if this was the correct place to post this but here goes...
Essentially, I'm using an Access frontend to SQL server backend. I'm wanting to make it so that if I open record 2301 for example, and Joe Bloggs also opens this record, only I can edit it. I've been playing with SQL server locking but to no avail. Forms are currently bound to SQL views with update triggers. (Took over a pre-existing project and am ironing out a few issues currently existing in the system).
I've tried XLOCK, ROWLOCK to no avail.
Any ideas?