What do I do when a message record is too large shows when adding.

C

Calvin

May somebody help please. I designed a database in Access and have been
entering records through the form suddenly a message comes up 'RECORD IS TOO
LARGE'' and i cannot enter more details. please help
 
D

Douglas J. Steele

A record cannot exceed 2000 bytes in size. However, since text fields only
take up as much room as is required to store the actual text they contain,
it's possible to define tables where it's possible to exceed the limit.

For example, it's valid to have a table with 10 text fields, each set to
allow 255 characters. You'll only run into problems when you actually put
more than 2000 characters total across the 10 fields.

You likely need to redesign your tables (or replace one or more text fields
with Memo fields)
 
T

Tom Wickerath

Top