Can't update/delete MySql records from Access2003

[ellenr]

I have a 600 record mysql db. It has a timestamp field, auto incr id field, several varchar fields and several smallint fields. The id field is set as primary key. The access03 has a form displaying most of the fields. It is the only table in the db. If I try to delete a record I get the msg "The doMenuItem was canceled" with no other explanation and the record is not deleted. If I try to update a record I get a msg "this record has been changed by another user since you started editing it..." and the save anyway option is grayed out. There is no one else using the db. A less important problem is the excessive time required to do a "find" in the file. 4 different locations will eventually be using this db.
Any help would be greatly appreciated, as I have spent the day with google without solving it!

[JKing]

Sounds more like an issue with the VBA code that is running behind your form. I suggest taking a look at your VBA code, specifically the code that is onclick of the buttons you mentioned.

I can't suggest anything else without more information. Some code would be great to see.

[ellenr]

strangely enough, what finally fixed it was changing a timedate field to a varchar field. Works as it should now.