473,554 Members | 3,241 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"Record is too large"?

Anyone:

I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I'll enter
info in a record, save the record, and try to move to another record and get
an Access error "Record is too large". The record is only half filled, with
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I'm getting that error, I
can't move to any other records in the DB until the record has been
'trimmed' of data. Suggestions, anyone??
Jack
aka te*****@earthli nk.net
Jun 27 '08 #1
25 20524
FYI...it doesn't matter what field I've added data to or which table is
affected, I get the same err msg whenever I appear to pass some threshold. I
can't find that error msg in any of the MSAccess documentation that I have
here, or anything that addresses restrictions to a records size. I'm in FORM
view when this happens.

"tekctrl" <te*****@earthl ink.netwrote in message
news:Gv******** *************** *******@earthli nk.com...
Anyone:

I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I'll
enter
info in a record, save the record, and try to move to another record and
get
an Access error "Record is too large". The record is only half filled,
with
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I'm getting that error, I
can't move to any other records in the DB until the record has been
'trimmed' of data. Suggestions, anyone??
Jack
aka te*****@earthli nk.net


Jun 27 '08 #2
What version of Access are you running and how big is the MDB file?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200806/1

Jun 27 '08 #3
tekctrl wrote:
Anyone:

I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I'll enter
info in a record, save the record, and try to move to another record and get
an Access error "Record is too large". The record is only half filled, with
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I'm getting that error, I
can't move to any other records in the DB until the record has been
'trimmed' of data. Suggestions, anyone??
Jack
aka te*****@earthli nk.net

It might help those that help you if you provide an error number as well
as the error message. Anyway...this is what it says in help.

"You defined or imported a table with records larger than 2K. This error
occurs when you enter data into the record, not when you define the
table structure. Redefine the table by making some fields shorter,
removing unneeded fields, or moving some fields to other tables."

You might have a text field like State that's set to 50 chars. Set it
to 2. See what else you can trim down in size by modifying your table
structure.

Jamaica Days
http://www.youtube.com/watch?v=q6CqtOJraBA
Jun 27 '08 #4
MSAccess 2002, sp3
6.6Mb

all running on a Win2K PC with 1Gb of RAM

"Linq Adams via AccessMonster.c om" <u28780@uwewrot e in message
news:8593f08eb0 070@uwe...
What version of Access are you running and how big is the MDB file?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200806/1

Jun 27 '08 #5
You need to take a look at this article:

http://support.microsoft.com/kb/111304

Part of what it says is that record size is limited to approximately 2000
characters, not counting memo fields (which are not actually held in the
record.)

Sometimes, when importing data, the field size, for all fields imported,
defaults to 255 characters, which can quickly add up. Unlike Access, many
flat files use a fixed length field format. You might want to go into the
Table Design View and check out the field sizes.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200806/1

Jun 27 '08 #6
Jamaica ... there was no err #, just the message.

Linq ... I believe you're right about the field sizes defaulting to 255 on
creation and then adding up to a LOT of wasted 'reserved' space. I went
back into the Properties and found and corrected a number that were like
that, including several single-character fields with a reserved field size
of 255. Also changed one Text field to a Memo type.

We'll see if my changes corrected the issue. Good thing I backed up the DB
first! <G>

Thank you, both! This is a very important DB and it's proper function is
critical here.
Jack

"Salad" <oi*@vinegar.co mwrote in message
news:M_******** *************** *******@earthli nk.com...
tekctrl wrote:
Anyone:

I have a simple MSAccess DB which was created from an old ASCII
flatfile.
It works fine except for something that just started happening. I'll
enter
info in a record, save the record, and try to move to another record and
get
an Access error "Record is too large". The record is only half filled,
with
many empty fields. If I remove the added data or delete some older
data,
then it saves ok and works fine again. Whenever I'm getting that error,
I
can't move to any other records in the DB until the record has been
'trimmed' of data. Suggestions, anyone??
Jack
aka te*****@earthli nk.net

It might help those that help you if you provide an error number as well
as the error message. Anyway...this is what it says in help.

"You defined or imported a table with records larger than 2K. This error
occurs when you enter data into the record, not when you define the
table structure. Redefine the table by making some fields shorter,
removing unneeded fields, or moving some fields to other tables."

You might have a text field like State that's set to 50 chars. Set it
to 2. See what else you can trim down in size by modifying your table
structure.

Jamaica Days
http://www.youtube.com/watch?v=q6CqtOJraBA

Jun 27 '08 #7
Linq:

Shuckey Darn! I reviewed the article that you suggested and went back into
the Design view for each of the tables. Edited the tables to shrink the
reserved field sizes, changed some to Memo type, saved and closed. Went
back into MSAccess and still having the same issue. :( I can add data and
save without problem, but when I try to move to the next record I still get
the "record is too large" msg. No err #. So far it's only affecting a
single record, but it's the single largest record in the DB even if only
half of the fields are filled. The Text (comments) fields which contain the
most data have all been changed to Memo type, and are all in separate tables
anyway, so they shouldn't be counting against the 2Kb record size limit.
I'm open to suggestions...a nyone?

Jack
"Linq Adams via AccessMonster.c om" <u28780@uwewrot e in message
news:85940cb2d9 5ee@uwe...
You need to take a look at this article:

http://support.microsoft.com/kb/111304

Part of what it says is that record size is limited to approximately 2000
characters, not counting memo fields (which are not actually held in the
record.)

Sometimes, when importing data, the field size, for all fields imported,
defaults to 255 characters, which can quickly add up. Unlike Access, many
flat files use a fixed length field format. You might want to go into the
Table Design View and check out the field sizes.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200806/1

Jun 27 '08 #8
tekctrl wrote:
Linq:

Shuckey Darn! I reviewed the article that you suggested and went back into
the Design view for each of the tables. Edited the tables to shrink the
reserved field sizes, changed some to Memo type, saved and closed. Went
back into MSAccess and still having the same issue. :( I can add data and
save without problem, but when I try to move to the next record I still get
the "record is too large" msg. No err #.
You might have an error routine in the sub to save the record. It might be
Msgbox Err.Description .

Guess what? There's an Err.Number. You can even do this
Msgbox Err.Number & "-" & Err.Description
But I told you what the err number was so you don't need to bother with
it. I even provided the info regarding that error.
single record, but it's the single largest record in the DB even if only
half of the fields are filled. The Text (comments) fields which contain the
most data have all been changed to Memo type, and are all in separate tables
anyway, so they shouldn't be counting against the 2Kb record size limit.
I'm open to suggestions...a nyone?
In help look for "Data Type Summary". This will list the storage
requirements for each data type.

Also, look for "Specifications " in help for your education.

Now, open up your table in design mode. Add up the storage space for
each field based on the data type and for Text the number of characters
you set for it. Don't add Memo or OLE Object fields. You will have
more than 2000 bytes. Fix it or continue to be stumped.

Jun 27 '08 #9
Salad wrote:
tekctrl wrote:
>Linq:

the "record is too large" msg. No err #.

I didn't supply the error number. The error number is 3047.
Jun 27 '08 #10

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

Similar topics

10
12821
by: KENNY L. CHEN | last post by:
Dear experts, I have two tables in my Oracle 8i database: TEST (COL1,COl2,REC_NO) and TEST1 (COL1,COL2,REC_NO). Both tables are unique-indexed on (COL1,COL2,REC_NO). I think the following SQL commands will return the same result but one of my friends don't think so. He said "QUERY 1" will return 1 unsorted record (ROWNUM < 2 ) first...
24
3577
by: hjbortol | last post by:
Hi! Is the expression "a >= b" equivalent to "a - b >= 0" in C/C++? Is this equivalence an IEEE/ANSI rule? Or is this machine/compiler dependent? Any references are welcome! Thanks in advance, Humberto.
0
2625
by: Dirk Försterling | last post by:
Hi all, a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following the instructions in the INSTALL file, including dump and restore. All this worked fine without any error (message). Since then, I found lots of the following in the postmaster output: 2003-11-29 15:19:54 ERROR: large object 4838779 does not exist 2003-11-29...
3
1446
by: Jeff | last post by:
I have 3 pages of data I need printed for each record, however, Access won't allow me to create a 3 page detail section. Is there any way around this limitation? Thanks in advance Jeff
3
2565
by: Vic | last post by:
Dear All, I have a database of laboratory records in Access 2000. There is one form which acts as an interface to input experimetal data. This form incorporates information from several tables. I have a flag (yes/no field) indicating whether a particular experiment (one record) is completed (ie all data belonging to that record is inputted...
1
1873
by: Just Me | last post by:
Table A contains a list of colors (example red, blue, green) Table B contains a variation of the colors in Table A (example light-red, medium-red, dark-red) To add a color variation to Table B, I want it to open a find record dialog box before it opens the form so that you can locate the main color you are going to enter the variations...
0
1061
by: Carlo Razzeto | last post by:
Hello there, I am currently working on an email archiving program that is supposed to copy the entier contents of an email (as downloaded via webdav from exchange) into a mysql database. This project is being written in C# with the use of the MySQLDriverCS driver for database connectivity (originally I was trying oledb with a mysql oledb...
4
1792
by: bugbear | last post by:
Hello; I have (tried) to change my geocities site to be "styled" not "tabled". It's certainly made the HTML nicer. But it doesn't work as nicely I'd like. And it almost doesn't work at all under IE.
3
1941
by: =?Utf-8?B?Sm9obiBXYWxrZXI=?= | last post by:
Hi, Below is sample output in x12 EDI format. I'm using vb.net to create this output file but i'm not sure if .NET has any tools to make the coding more organized and/or efficient. Right now the only way i can think to create each segment is by hardcoding the different elements into a string. For example, to create the N1 segment i'll do...
0
7589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7516
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7787
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6131
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5428
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3539
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1121
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.