Write Conflicts on a Continous Form

[mrliam69]

I have developed a production program that uses a continuos form to display all the production items and throughout the day the users are updating the form by checking off various fields. Now and again I get the situation where 2 people are accessing the same record at the same time and the get a write conflict/save to clipboard message.
Is it possible to stop this happening.??


Liam

 

[cmmrfrds]

Is this an Access Project (ADP)? What level of locking are you doing on the table? What type of Lock? Is the data source on the Form a pass-thru query, table, sql string, etc... If you could supply this type of information, that would be a starting point to venture an answer.