inconsistent error importing data

[astro]

I got a message from a client. They tried to import some data into an
Access application and got the following error:

"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data"

I ran the same import on my office PC and did not get the error. I dailed
up their server, did the same import and got the error. I then stepped
through the import code and the error did not trigger. I then ran the
import without the debugger and no error. I then ran the import 4 more
times and no error! Same data, same steps....

Any ideas?

Thanks

[Bob Quintal]

Re: inconsistent error importing data

"astro" <astro-puppy@mn.rr.com > wrote in
news:ITbnd.5550 0$T02.53967@twi ster.rdc-kc.rr.com:
[color=blue]
> I got a message from a client. They tried to import some data
> into an Access application and got the following error:
>
> "The field is too small to accept the amount of data you
> attempted to add. Try inserting or pasting less data"
>
> I ran the same import on my office PC and did not get the
> error. I dailed up their server, did the same import and got
> the error. I then stepped through the import code and the
> error did not trigger. I then ran the import without the
> debugger and no error. I then ran the import 4 more times and
> no error! Same data, same steps....
>
> Any ideas?[/color]

Your client did not send you the file that caused the error. That
error comes from a string with more characters than the field
width.



--
Bob Quintal

PA is y I've altered my email address.

[astro]

Re: inconsistent error importing data

I tested against the same data set she did. I tested the same account she
imported. I then tested on the same sever with the same data with the same
account....




"Bob Quintal" <rquintal@sPAmp atico.ca> wrote in message
news:1100830701 .WmHPekduah7pat tGNleKUQ@terane ws...[color=blue]
> "astro" <astro-puppy@mn.rr.com > wrote in
> news:ITbnd.5550 0$T02.53967@twi ster.rdc-kc.rr.com:
>[color=green]
> > I got a message from a client. They tried to import some data
> > into an Access application and got the following error:
> >
> > "The field is too small to accept the amount of data you
> > attempted to add. Try inserting or pasting less data"
> >
> > I ran the same import on my office PC and did not get the
> > error. I dailed up their server, did the same import and got
> > the error. I then stepped through the import code and the
> > error did not trigger. I then ran the import without the
> > debugger and no error. I then ran the import 4 more times and
> > no error! Same data, same steps....
> >
> > Any ideas?[/color]
>
> Your client did not send you the file that caused the error. That
> error comes from a string with more characters than the field
> width.
>
>
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.[/color]