Solved

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

Posted on 2004-09-17
4
219 Views
Last Modified: 2006-11-17
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?

0
Comment
Question by:mysticaljoey
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Jonathan Kelly
ID: 12084179
try installing latest service packs for access and jet
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12085233
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
 
LVL 36

Accepted Solution

by:
SidFishes earned 250 total points
ID: 12089213
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
 
LVL 36

Expert Comment

by:SidFishes
ID: 12139852
umm...can I ask why you gave this a grade of c??
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now