srini
Jul 2nd, 1999, 07:59 PM
I am using VB5 dao 3.5 with ms-access, I have a master details entry
screen where
I am using transaction, I use commit or rollback depending on save of
cancel. It
works fine when only one user is adding/editing records, the movement
more than
one user starts adding records then I get an error that the record is
locked by another
user (first user).
After going through the vb/ms-access documentation I came to a
conclusion that this
could be because of page locking.
My question is that, why cannot two or more users add new records
simultaneously as
there is no need to lock records? Secondly, is there any other way to
use transactions to
over come this problem?
Thanks
Srini
screen where
I am using transaction, I use commit or rollback depending on save of
cancel. It
works fine when only one user is adding/editing records, the movement
more than
one user starts adding records then I get an error that the record is
locked by another
user (first user).
After going through the vb/ms-access documentation I came to a
conclusion that this
could be because of page locking.
My question is that, why cannot two or more users add new records
simultaneously as
there is no need to lock records? Secondly, is there any other way to
use transactions to
over come this problem?
Thanks
Srini