G
Guest
Hi All
Just how do developers sensibly handle record locking conflicts in this
situation:
I have a multiuser FE/BE A2002 database. There is a single form for both
data entry and subsequent re-editing. The main form is bound to the Sales
Order header table, and the child form to the Line detail table. I decided to
use a transaction so that the user may enter/edit the entire order and
save/abandon it entirely (which seems to be 'universal' behaviour for this
type of interface). This is of course where it comes unstuck! I assumed
(foolishly) that I could use optimistic, record-level locking and get away
with it. The whole thing works beautifully for a single user, but
practically, only one user at a time may enter/edit data because the
possibilty of multiple dirty rows in the subform appears to force Jet to
switch to page-level locking...help!!
I'm using DAO bound recordsets, because I'm only really familiar with DAO -
could ADO help me out here?
I wondered about using an unbound form, or bound form with unbound controls,
but I can't imagine how I could display the multiple detail rows without the
bound subform in datasheet mode.
This must be a classic programming challenge - forgive my ignorance!
Any and all suggestions appreciated.
Ali Kwok
Just how do developers sensibly handle record locking conflicts in this
situation:
I have a multiuser FE/BE A2002 database. There is a single form for both
data entry and subsequent re-editing. The main form is bound to the Sales
Order header table, and the child form to the Line detail table. I decided to
use a transaction so that the user may enter/edit the entire order and
save/abandon it entirely (which seems to be 'universal' behaviour for this
type of interface). This is of course where it comes unstuck! I assumed
(foolishly) that I could use optimistic, record-level locking and get away
with it. The whole thing works beautifully for a single user, but
practically, only one user at a time may enter/edit data because the
possibilty of multiple dirty rows in the subform appears to force Jet to
switch to page-level locking...help!!
I'm using DAO bound recordsets, because I'm only really familiar with DAO -
could ADO help me out here?
I wondered about using an unbound form, or bound form with unbound controls,
but I can't imagine how I could display the multiple detail rows without the
bound subform in datasheet mode.
This must be a classic programming challenge - forgive my ignorance!
Any and all suggestions appreciated.
Ali Kwok