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

Reply via email to