Write Conflict

[sandybair]

I have an Access 97 database with tables linked from a mySQL database via ODBC. When attempting to update data in a form which contains a subform, I get write conflict errors which state that the record has been changed by another user and which ask me to copy the record to the clipboard or to drop the changes. How do I get rid of this error and what is causing it?

 

[Broccoli2]

For the Access/MyODBC/MySQL setup to work correctly, make sure you have:

1. A primary index defined for every table you want to be able to update
(Add with:

ALTER TABLE tblname ADD PrimaryID int not null primary key auto_increment;

)

2. A timestamp field defined in every table you want to be able to update
(Add with:

ALTER TABLE tblname ADD stamp timestamp;

)

I got similar problems until I realised about No. 2.

Have you got both of these set up?

-Rob

 

[markstangroom]

I have the same problem with my datadase but I already have primary key & timestamp fields. The database only works in Access if I delete the primary key. But I need this to produce my auto_incremented reference numbers.

Does anyone have any ideas?

Thanks

Mark