Problems when using Linked tables

Problems when using Linked tables

am 19.03.2010 12:30:15 von Jorge Urtiaga

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?

Thanks
Jorge

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems when using Linked tables

am 19.03.2010 17:54:37 von Shawn Green

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-usagen otes-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/myodbc?unsub=gcdmo-myodbc@m.gmane.org