Alex, If MyODBC is simply passing the query in this case along to MySQL, the MySQL engine will choke on the subquery IN (SELECT ..., since MySQL doesn't support subqueries. I have had success, however, using subqueries with Access and MySQL by linking the MySQL tables to Access using the Get External Data menu command, then processing the tables in Access.
Hope this helps. Cheers, Fred Woolsey -----Original Message----- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 6:29 AM To: [EMAIL PROTECTED] Subject: ODBC Call Fails Hi all, Not sure if this is the right place to ask this one but here goes! I'm trying to export an Access 2000 database to MySQL and remain using Access as the front end. Everything seems to be working fine, except for this one line of code which is giving me and ODBC call failed error. CurrentDb.Execute "DELETE * FROM SpecialismForContacts WHERE (SpecialismForContacts.ContactID=" & Forms!frmPhotographingContact!txtContactID & ") AND (SpecialismForContacts.SpecialismID IN (SELECT SpecialismID FROM Specialisms WHERE Specialisms.AreaID=" & cboArea & "))", dbFailOnError Does anyone have any insights to why this is? Alex --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
