Update query fails due to lock violations

[Guest]

Greetings.

Running an update query in Access 2003 on linked MySQL tables via ODBC,
running MySQL on a Windows 2003 Server. The query fails, returning the
message that the query didn't update 103 records due to lock violations.

This same query runs just fine when run against the same dataset where MySQL
is running on a Linux machine.

Thanks for the help.

Danny

 

[Guest]

This is probably not a good place to ask about MySQL,
but guessing that MySQL is not configured the same on
both servers? Is one configured as transactional and the
other not?

(david)

 

[Guest]

They are both configured as transactional.

Re appropriateness of the question: I'm trying to troubleshoot a Microsoft
error message, using a supported (ODBC) configuration. Is there a better
Access subgroup to post to?

 

[Guest]

Have you tried running your ODBC query from
Excel instead of from Access? What you describe
doesn't sound particularly like an Access problem
to me.

(david)