Write Conflict Error

[Simon]

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'

 

[Arvin Meyer [MVP]]

The problem is probably occuring because MySQL is a server based engine
which doesn't like bound forms. You may need to explicitly save the main
form before moving to the subform, so that you can get the link field for
the many-side subform. SQL-Server handles this with ADPs or a JET overlay in
an MDB. Forcing the save may solve your problem.

 

[Armen Stein]

Or, it could be that there is a record version problem, which may be
resolved by simply adding a Timestamp field to each MySQL table. I'm
not an expert with MySQL, but other posts have indicated that this
works similarly to the Timestamp/RowVersion in SQL Server.

You can use bound forms with server-based database, if you follow some
best practices: open your bound forms to only one main record at a
time, and make sure you have a fairly fast and reliable network
connection.

The problem is probably occuring because MySQL is a server based engine
which doesn't like bound forms. You may need to explicitly save the main
form before moving to the subform, so that you can get the link field for
the many-side subform. SQL-Server handles this with ADPs or a JET overlay in
an MDB. Forcing the save may solve your problem.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com