Re: Problems when using Linked tables

Jorge Urtiaga wrote:
>  Dear,
> 
> we are using:
> 
> ODBC Driver Version: 5.1
> MSAccess Version:
> MySQL Server version: 5.0.51b- community-nt via TCP/IP
> 
>  From the MsAccess database, where we have the linked MySQL tables, we 
> are sending an Update query (we are tying to update the MySQL tables). 
> For some strange reason when the update query does not really change any 
> field value (I mean the update is for example to "Update tablex set 
> Field0 = '5'" and the Field0 has already a '5' ) we get a message 
> informing the changes are not possible because another user is trying to 
> modify the same data.
> 
> Can someone help on this?
> 

MS Access uses timestamp information to detect the last change to a 
particular row of data. Have you tried modifying your MySQL schema to be 
more MS Access compatible along the lines of the suggestions documented 
in this link?
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-usagenotes-apptips.html

If you have, which techniques did you try? What were their results?

-- 
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]