Access database "Locks Up"

G

Gert

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top