Hi all, I have an application that is running under Access 2000 connected to a MySQL backend (3.23.46) via ODBC 3.51.
Currently I'm trying to run a query and then scroll through the results inserting into a table via the ODBC link. All is well with the fields which contain numbers, but the longer field holding text information is giving an Automation Error (440) or more specifically -2147217911 (80040e09). The data itself is a title for an image up to 80 characters and I'm inserting into a char field of 80 characters. The error itself seems to be saying there's an error in the SQL syntax, but the point it is flagging up is actually within the data after the first word. Any ideas or help gratefully received Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 19/02/2002 --------------------------------------------------------------------- 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