Hi, I have an application written in MS Access 2000 which has linked tables from a MYSQL database.
I'm having a problem running queries which update the linked tables. I can update individual records ok from Access, but as soon as i tried to run a query, the query failes saying X number of records failed due to lock violations. I have tried the same in Access 97 and i still get the same problem. Any Idea's All help greatly appreciated. Configuration Details. Mysql server 3.23.39-nt MyODBC 2.50 MS Access 2000 MDAC 2.6 Thanks, Paul Paul Kemp KB Technology Tel. 01892 544107 Mob. 07949 151061 Email. [EMAIL PROTECTED] Web. www.kbtech.co.uk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php