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
