Write Conflict Error

I have a database with access as front end and Mysql as back end. I am
gettting the following 'Write Conflict' Error. when i am on my order
form, This form does has a subform where i enter all the products that
are ordered.

Could any one let me know what could cause this problem. I am the only
one using the database as its still in the build stage

Thanks


'Write Conflict

This Record has been changed by another user since you started editing
it. If you save the recorded you will overwrite the changes the other
user made

Copying the changes to the clipboard will let you look at the values
the other user entered and then paste your changes back in if you
decide to make the changes'

Re: Write Conflict Error

S.Dickson@shos.co.uk wrote:

> I have a database with access as front end and Mysql as back end. I am
> gettting the following 'Write Conflict' Error. when i am on my order
> form, This form does has a subform where i enter all the products that
> are ordered.
>
> Could any one let me know what could cause this problem. I am the only
> one using the database as its still in the build stage
>
> Thanks
>
>
> 'Write Conflict
>
> This Record has been changed by another user since you started editing
> it. If you save the recorded you will overwrite the changes the other
> user made
>
> Copying the changes to the clipboard will let you look at the values
> the other user entered and then paste your changes back in if you
> decide to make the changes'
>

Evidently you are taking too long to update a table/record while others are also
updating that same table/record. Based on what I have read so far WRT MySQL
transactions atomicity, it leaves a lot to be desired.

If you see this frequently, you may want to single-thread your transactions by
locking tables prior to user. See:
http://dev.mysql.com/doc/refman/5.1/en/lock-tables.html

This also means that you must keep your database transactions as short as possible.


--
Michael Austin.