I have a VBA-application that's used simultaneously by several people. The
application is stored locally and the access database is stored centrally on
the network. We work in a "continuous form". In most case, everything works
fine, except when someone starts editing a record without saving it (it's
just left open while (s)he does other things) or when a new record is created
without saving it. In these case, no-one else can edit any record in this
table. When the initial record is released (saved), the others can again edit
their record.
"Record Locks" is set at "No Locks". I have tried tp set Record Locks to
"Edited record" but this doesn't solve the problem.
Does anyone have a solution for this?

Hi,
try to set "Open database using record-level locking" flag in
options/advanced

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



"Gert" <(E-Mail Removed)> wrote in message
newsE6784BD-B9B9-4836-9428-(E-Mail Removed)...
> I have a VBA-application that's used simultaneously by several people. The
> application is stored locally and the access database is stored centrally
> on
> the network. We work in a "continuous form". In most case, everything
> works
> fine, except when someone starts editing a record without saving it (it's
> just left open while (s)he does other things) or when a new record is
> created
> without saving it. In these case, no-one else can edit any record in this
> table. When the initial record is released (saved), the others can again
> edit
> their record.
> "Record Locks" is set at "No Locks". I have tried tp set Record Locks to
> "Edited record" but this doesn't solve the problem.
> Does anyone have a solution for this?
>