DAO record size 2K limitation in Access 97

[Rodolfo]

When populating a table I get an error stating that the
record size is too large. The error number is 3047.
According to Access 97 there is a 2K limitation for all
records. Is there a way that I can increase this limit to
4K or even 6K? Or if this won't solve the problem, is
there another way around the 2K limitation?

 

[Heiko]

Hello Rodolfo
you should normalize your table.
Heiko

 

[Albert D. Kallal]

You must have some fields with a LOT of text, or perhaps you have a lot of
fields. I know of many developers who have developed systems from job
costing to simulation software, and with excess of 20 years of developing
database systems, they have NEVER developed an application with more then 60
fields.

On the other hand, you might actually have a few fields that are quite long.
The solution is to move out those long fields to a memo type field, and thus
there is NO limitation on the amount of text, or record size when you do
this. However, be fore warned you can not simply start changing fields to
memo type fields without some consequences. For example, memo fields cannot
be indexed for searching, and they some what less reliable. Hence, you only
want to use them when really need to.

As mentioned, you might want to normalize the data if you have a lot of
fields.

ACC2002: Database Normalization Basics
http://support.microsoft.com/?id=283878

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Data Normalization Fundamentals by Luke Chung
http://www.fmsinc.com/tpapers/datanorm/index.html

324613 - Support WebCast: Database Normalization Basics
http://support.microsoft.com/?id=324613