Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
> -----Original Message-----
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:52 AM
> To: '[EMAIL PROTECTED]'
> Subject: Access to MySQL Column Type Error
>
>
> I'm trying to do an append query in Access to MySQL on CompanyRep table.
> BTW, I'm using MyODBC to allow connectivity between MS-Access and
> MySQL. Now
> I've done many queries like this with no problem. For some reason this
> append query will not work anymore. I get the following error message
>
> "Microsoft Access can't append all the records to the table"
>
> "Microsoft Access set 148 field(s) to Null due to a type
> conversion failure,
> and it didn't add 0 record(s) due to key violations, 0 record(s)
> due to lock
> violation, and 0 record(s) due to validation rule violations."
>
> This error seems to occur only on the Fax_Machine_ID field based on what I
> see missing for data in MySQL. Any help would be greatly appreciated,
> thanks!
>
> Schema for Fac_Machine_ID field on Access...
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
> | Field | Date_Type | Null | Key | Default | Extra
> |
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
> | Fax_Machine_ID | text(4) | YES | | NULL |
> |
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
>
> Schema for Fax_Machine_ID field on MySQL...
>
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
> | Field | Type | Null | Key | Default | Extra
> |
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
> | Fax_Machine_ID | varchar(4) | YES | | NULL |
> |
> +--------------------+--------------+------+-----+---------+------
> ----------
> +
>
> Specs...
>
> Microsoft Windows Side
> ----------------------
> Microsoft Access 2000 (9.0.3821 SR-1)
>
> OpenBSD v2.8 Side
> ----------------------
> MySQL (unix) v3.22.32
>
> ---------------------------------------------------------------------
> 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
