473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

inconsistent error importing data

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
Nov 13 '05 #1
2 1694
"astro" <as*********@mn.rr.com> wrote in
news:IT*******************@twister.rdc-kc.rr.com:
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?


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.
Nov 13 '05 #2
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" <rq******@sPAmpatico.ca> wrote in message
news:1100830701.WmHPekduah7pattGNleKUQ@teranews...
"astro" <as*********@mn.rr.com> wrote in
news:IT*******************@twister.rdc-kc.rr.com:
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?


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.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Byron Morgan | last post by:
Anyone run into this before? I have a python app that has been reliable, running for days on end without a crash. Suddenly, It repeatedly crashes with the following message: "Fatal Python...
0
by: Daryl Zavier | last post by:
Hi Gurus, Please forgive me if my question is dumb cause this is my first web application I've done. Currently in my web application there is a button to click which will fire off a DTS event...
0
by: jlea | last post by:
I'm getting the following link error in my C++/.NET C++ project: error LNK2022: metadata operation failed (8013118D) : Inconsistent layout information in duplicated types (tagTOOLINFOA):...
9
by: advance scout | last post by:
HELP! My database is suddenly corrupted. My computer was acting funny (very sluggish) and was shut down. Access had been already been closed down but computer was acting very slow , so perhaps it...
5
by: Mike Collins | last post by:
I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble...
1
by: puremetal33 | last post by:
I have worked very little with Access and have hit a snag. My task right now is to import the data from a spreadsheet into an existing table in an Access database. I edited the .xls file so that...
20
by: Francine.Neary | last post by:
I am learning C, having fun with strings & pointers at the moment! The following program is my solution to an exercise to take an input, strip the first word, and output the rest. It works fine...
5
by: Abhishek Bhatt | last post by:
I need to import data programatically from spreadsheet file into database table. There are 30 such tables. User can upload multiple files at a time. For a table(which does not have any referential...
3
by: nimajneb via AccessMonster.com | last post by:
Can anyone offer me any insight on the following problem? I have an Access database on a company shared drive. I'm the designer and the only user (so far). Suddenly, any time I try to open a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.