Mysql/Access ~ unable to update record because another user already did

Hi, I got a database the link to Mysql. i'm very new at this and have encounter a problem that prevented me form venturing forward.
A "one to many" relationship between two tables (tbl_Ship,tbl_Shipjourney) link to a form with subform in access.

[tbl_ship] only have 1 primary key (ship_id:[ auto_increment]).
[tbl_shipjourney] has 2 (ship_id:int , route_id: [auto_increment]).

The problem is with the subform, it records the journey detail of a ship. Entering a new record worked perfectly but until i decided to correct some mistake in the subform. The funny thing is, only the first record of each ship (subform) is un-updatable. The rest is ok.

When i try to update the first record, MSaccess will pop up a dialog saying there is another user updating it.

Can anyone tell me how to fix this?

mysticaljoeyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SidFishesConnect With a Mentor Commented:
Jet/access often don't like the precise timing schemes of sql server and mysql...sometimes adding and timestamp field to your tables and queries will clear up the problem
0
 
Jonathan KellyCommented:
try installing latest service packs for access and jet
0
 
shanesuebsahakarnCommented:
Do you have any code that is updating the record via SQL?

Also, are you using the latest version of the MySQL ODBC driver?
0
 
SidFishesCommented:
umm...can I ask why you gave this a grade of c??
0
All Courses

From novice to tech pro — start learning today.