Share via

Record too large for Access.

Anonymous
2017-07-04T13:17:41+00:00

My case.. i cannot add more text to access.. Ms access show me   " Record to large" what is happen? So how can i Fix this case. i have many

i have many  360 field. 1---------->>>360.  type  is short text all some long text .

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

13 answers

Sort by: Most helpful
  1. Anonymous
    2017-07-04T22:24:02+00:00

    My friends here are quite correct about the need to redesign; just one additional tidbit. One of the more obscure specifications of Access is that any single record is allowed no more than 2048 bytes actually occupied (Memo fields not included); this can be a nasty problem if you have, say, 100 Short Text fields. If they are filled with four or five bytes each, the database will work; if a verbose user fills the 100 fields with 25 bytes each, BANG you get this error. It can be nasty because the database may have worked fine for years until this user came along!

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-07-04T14:06:58+00:00

    Thank you for all Deniel

    Was this answer helpful?

    0 comments No comments
  3. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2017-07-04T13:52:41+00:00

    Daniel is right: your database design is incorrect. A relational database engine like Access is not a spreadsheet.

    Access specifications (including max fields) are here: https://support.office.com/en-us/article/Access-2016-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

    Was this answer helpful?

    0 comments No comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2017-07-04T13:52:05+00:00

    Access is NOT a spreadsheet. Its a relational database and data should be stored relationally. Relational tables should be tall and thin not wide.

    So you need to review and redesign your table structure. If you explain what your database is supposed to do and the data you are capturing we can suggest proper structure.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2017-07-04T13:44:18+00:00

    360 fields?

    Access can only have a maximum of 255 fields, and even then anything above 20 I seriously start to question the data normalization.

    I'd urge you to read up on normalization (splitting your data), you can find some good material on the subject at http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html

    As for short text vs long text, this is simply a matter of defining your field using the proper data type, so simply go into design mode and set the appropriate data type for each field.

    Lastly, if you explain your situation in detail, we could offer better guidance.

    Was this answer helpful?

    0 comments No comments