Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 25th, 2008, 09:16 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Default The field is too small to accept the amount of dat

Hi, all

I create a VB project using Access to store data. Everything works fine in my computer. But when I install this project to other computer, when project read a text file and isert data to DB, it get the followig error:
The field is too small to accept the amount of data you attempted to add.Try inserting or pasting less data

Can anybody tell me what's wrong? why it works in one computer, but not work in other computer, access database is same.

Thanks.

 
Old October 26th, 2008, 03:05 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

You are inserting too much data into the field..are you using the same database in the two computers?? are you pasting the same amount of data???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old October 27th, 2008, 10:18 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, I use the same database and passing the same data. because I will read a text file to db, they use the same text file.
I have solve this issue by change one of the data type from "Text" to "Memo".

Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting a flexible amount of text from a field scottiegirl PHP Databases 2 July 28th, 2008 09:57 AM
Dat aRelations lovesyogi C# 1 May 24th, 2007 10:12 AM
To delete and Accept a row in DataGrid vijay_83 ASP.NET 1.0 and 1.1 Basics 3 September 19th, 2006 02:15 PM
How to accept apostrophe entered by user karjagis Access ASP 0 April 6th, 2004 06:21 AM
How to make integer to accept null value ganesh15 PHP How-To 3 August 18th, 2003 01:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.