(Editing Record issues in Access / SQL (Write Conflict

زمان بردن جداول به Sql حتما چک کنید فیلدهایی که پرایمری کی نیست و نباید Null باشد  پر شده باشد وگرنه خطا میدهد  

Int

Bigint

Is there a bit field in your table? i.e. ‘1 or 0 ‘ or ‘yes or no’?

I’ve seen Access kick back those errors on linked tables with a bit field and no default value set.

You might want to add a timestamp field to the table as that seems to often resolve this problem.

Another possibility is that you are editing a record in a form and the form is dirty (i.e., edits not saved) and you run code that uses DAO or ADO to run SQL to update the same record. Jet sees that as 2 users editing the same record. Try to force a save before running the SQL update:

If Me.Dirty Then

Me.Dirty = False

End If

[run SQL update here]

When a record is saved, Microsoft Access sets the Dirty property to False. When a user makes changes to a record, the property is set to True.

زمان تغییر True و ذخیره False 

Form.Dirty event (Access)  : 

زمان تغییر محتویات کنترل مشخصی اتفاق می افتد

The Dirty event occurs when the contents of the specified control changes.

نوشتاری : 

Syntax : 

expression.Dirty (Cancel)

این تنظیم تعیین می کند آیا رخ می دهد یا خیر ، تنظیم آرگومان Cancel به True

Cancel : 

The setting determines if the Dirty event occurs. Setting the Cancel argument to True