Record is too large. (Error 3047)

  • Thread starter Thread starter kbsmith
  • Start date Start date
K

kbsmith

I have a relatively large amount of data that I've imported into an Access
table and since some of it is survey data (with some relatively verbose
open-ended responses) I was not shocked to get this error when I tried to
make changes to the table. However, I've deleted these open-ended response
fields and am still getting the error. Is there an easy way to track down
which field is giving me the issue?
 
Where? Where are you getting this error? What are you attempting to do
when this error shows up?

Are you attempting to delete the fields from Access tables, or are you
deleting the fields before import?

Which version of Access?

How many fields? ?size & data types?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
kbsmith said:
I have a relatively large amount of data that I've imported into an Access
table and since some of it is survey data (with some relatively verbose
open-ended responses) I was not shocked to get this error when I tried to
make changes to the table. However, I've deleted these open-ended response
fields and am still getting the error. Is there an easy way to track down
which field is giving me the issue?
Click to expand...
 
iletide şunu yazdı said:
I have a relatively large amount of data that I've imported into an Access
table and since some of it is survey data (with some relatively verbose
open-ended responses) I was not shocked to get this error when I tried to
make changes to the table. However, I've deleted these open-ended response
fields and am still getting the error. Is there an easy way to track down
which field is giving me the issue?
Click to expand...
 
I have a relatively large amount of data that I've imported into an Access
table and since some of it is survey data (with some relatively verbose
open-ended responses) I was not shocked to get this error when I tried to
make changes to the table. However, I've deleted these open-ended response
fields and am still getting the error. Is there an easy way to track down
which field is giving me the issue?
Click to expand...

There is a 2000 character (4000 byte with Unicode) limit on the total space
actually occupied in any single record in a table. As Jeff says, it would help
a lot to know the structure of your table. At a guess, you've made the very
common survey design error of having one field per question (a "wide-flat" or
"spreadsheet" design) instead of the normalized design, with one RECORD per
answer in an Answers table, related many-to-one to a table of Questions and to
a table of Surveys.

You can handle verbose answers by using a Memo field rather than a Text field;
a memo counts only 18 bytes toward the 4000 byte limit, no matter how
loquacious the content (you still have a 2GByte limit on the entire database
though!)

More info please?
 
Back
Top