Write conflict

[Alan T]

I tried the following to add new record:
1)use query
2)use recordset to add record, then assign value to the field by field

At the end, Access always pop up a 'Write Conflict' message box to ask me
there are changes of the current by other user.
I need to choose 'Save record', 'Copy to clipboard' or 'Drop changes'

Why I got this message?

 

[Sylvain Lafontaine]

Maybe a missing primary key in the table(s).

 

[Ofer Cohen]

Are you using SQL Server tables?
I had this problems few times, my work DBA doesn't allow me adding a data
stamp saying that it cause alot of problem to the database.
I had to change the field type from True/False to Small int, and the problem
was solved.

 

[John W. Vinson]

I tried the following to add new record:
1)use query
2)use recordset to add record, then assign value to the field by field

At the end, Access always pop up a 'Write Conflict' message box to ask me
there are changes of the current by other user.
I need to choose 'Save record', 'Copy to clipboard' or 'Drop changes'

Why I got this message?

You may not need to do all of this.

If you have a Query open, and at the same time you're trying to update the
same table in code (or from a form), the other user *is you* - you can't be
editing the same record twice using different processes.

Could you explain what you're doing - perhaps post your code? It may be
simpler than you think!

John W. Vinson [MVP]