Write Conflict

[Dillen]

We moved the backend of an MS Access app from Access to SQL-Server.

Now we see the following behaviour
- We can create new records
- We can update old records
- We CANNOT update new records: We get the famous WriteConflict message with "Save Record" greyed out.

Any explanation for this behaviour?

PS: In our FE we open a form and just close the form. All fields are bound to the database tabeles. So no explicit SQL INSERT/UPDATE command used.


Christof.

 

[Dillen]

Solved

Problem was related to a BIT1 field.
After conversion to CHAR 1 it works fine.

Christof.