sqlite-odbc write conflict

[am2]

I try to connect a sqlite- database via odbc (http://www.ch-werner.de/sqliteodbc/).
I copied a table and added a primary key column to achieve this.

The table without PK (but with other constraints) is write protected, the table with PK seems to be writable. I can open the table, change the content of a field but if I want to move to another row to save the changes I get an write conflict error, row has been changed in the mean time. Of course no one changed this.

Has anybody an idea what I can/must do?

 

[am2]

It seems to connected to the date- fields.
If I try the same with a table without date fields it works.
If I remove the date fields from the mentioned table it works with this table too!

But it can not be the solution to kill all date- fields (or to alter it into text or sth like this.
Any ideas?

 

[Bogumil]

I have the same problem. Even without data field I can't update records added in MS Access... If you found a solution would be great...