could not update;currenty locked

[Lisa]

I have a multi user environment where users are assigned to particular
records. I have created a form based on SQL to get the data from the table
and only provide them the records they are assigned to . .. They continue to
get the error could not update; currently locked error. I have No Locks set
on the database and form. Currently I have it in a one database environment
but going to change it to an FE / BE environment. Is there anything else
that will eliminate this error from ocurring.

Thanks for any information you can provide.

 

[J_Goddard via AccessMonster.com]

Hi -

We need nore information here -

When exactly do the users get this error? Are they able to get in to the
database and if so, can they open the form you are referring to? What is
the application attempting to update when the error occurs?

John