Max record size exceeded

[Guest]

Hi,
If possible, how may I extend the maximum record size that ACCESS will accept?

Here is the error message I got:

Record is too large. (Error 3047)
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.

Thanks.

David

 

[John Vinson]

Hi,
If possible, how may I extend the maximum record size that ACCESS will accept?

Here is the error message I got:

Record is too large. (Error 3047)
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.

Well, the error message answers your question: make some fields
shorter, remove unneeded fields, or move some fields to other tables.

You're limited to 2000 characters per record, exclusive of Memo fields
(each memo field, no matter how much text it contains, contributes 16
bytes to the 2000 byte limit).

In practice, this limit is often a problem only when your table is
improperly normalized. If you have one or more one-to-many
relationships embedded in each record you'll run out of room; if these
are split out into multiple tables you won't. Could you describe the
structure of your table and the nature of the data? Perhaps someone
could suggest a normalized solution to avoid this error.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps