Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

URGENT !!Microsoft JET Database Engine error '80040e21

Posted on 2003-03-20
3
Medium Priority
?
971 Views
Last Modified: 2012-05-04
Hi
I get this error when i try to insert data larger than 50 characters.

I am using ASP with Access database.

The error is

“Microsoft JET Database Engine error '80040e21' The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data”

thanks

0
Comment
Question by:hp2222
  • 2
3 Comments
 

Accepted Solution

by:
darkmagneto earned 300 total points
ID: 8177934
Check the Access database table.  By default Access places 50 as the character limit.  255 is the maximum for all fields except for Memo Fields (Which have no limit).  You are probably exceding that limit...check the table and make sure.

Dark
0
 
LVL 5

Expert Comment

by:cempasha
ID: 8180585
0
 
LVL 5

Expert Comment

by:cempasha
ID: 8180589
but probably darkmagneto is right about it
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
By following these Magento e-commerce development tips, you can increase your website's conversion and profitability. Read this post for more details.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Suggested Courses
Course of the Month15 days, 23 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question