Update query fails due to lock violations

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query fails due to lock violations 1
Access Lock Violations 0
VBA Code to Connect and Query a MySQL Table 12
Lock Violations 4
Union Query Problem 6
Access lock violation 2
Access front end via ODBC to MySQL 2
Sub query size restrictions 2

Back
Top