Well I did the trace and it's about 2.81MBs. What exactly do you need out of
it? I didn't notice much help from it but then again I'm not very knowledge
in that area. Considering the size do you still want me to directly e-mail
it to you?
One other thing I forgot to mention was the data in the Fax_Machine_ID field
starts with a * and then 3 integers (max size 4). There are the odd few that
do not have a * in front and those seem to get through. Would this maybe be
taking as a wildcard and I would have to escape it some how so I will be
able to append the query over to MySQL successfully?
> 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 |
> > |
> > +--------------------+--------------+------+-----+---------+------
> > ----------
> > +
---------------------------------------------------------------------
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
