Record locking in Forms

[Colin Chaney]

I've got about 30 users logging call onto a Data Base at
the same time, every now and then it will tell the user
that the form is currently lock for editing. Non of the
users are editing the same query, but all of them are
writing to the same Data Base.

What am I to do to get rid of this problem.

 

[Lynn Trapp]

I'm not exactly sure what the scenario is. You mention a Form being locked
for editing and you also mention editing a Query. When you say "edit" are
you referring to simply entering and updating data or making structure and
design changes to the Form and/or Query?

 

[TC]

Your database is probably not using record level locking - and it
apparently has not been programmed to allow for this!

By which I mean:

Your database is probably not using record level locking, *and*, it
apparently has not been programmed to allow for the effects of record
locking conflicts.

TC