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

[Guest]

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

 

[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)

 

[Guest]

To add a little to Doug's answer, Access MVP Allen Browne offers a free
utility that you can download which, among other things, will identify tables
in your database that can potentially exceed 2000 characters. You can get a
copy here:

Database Issue Checker Utility
http://allenbrowne.com/AppIssueChecker.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________