Record is too large MS Access runtime error

问题:

I have an abnormally large table for one of my applications in MS Access. It violently breaks some rules of normalization, but is otherwise fine for this small application. It has ~100 fields(columns). I have read the limitation specifications here but can't see where I violate any of these. Most of the fields are text fields, and range from a couple words to a couple of sentences. My questions are:

1. Is there a way to get a more descriptive error than "record is too large", so that I can determine how to make it smaller?

2. Would changing my 'text' fields to 'memo' fields decrease the size of my record?

At first glance, of all of the specifications potentially violated, this :Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes :: 4,000
appears to be the most likely culprit.

3. Would this violation potentially give the "record is too large" runtime error(while filling out a form).

4. Would setting the UnicodeCompression property to 'no' positively or negatively impact the performance?

回答1:

Memo fields are likely to be the answer. The record limitation rules do not include memo data type.

回答2:

Seems the limit for fields is 2000 bytes (Memo and OLE are not counted with this restriction). With ~100 fields, you are likely to be hitting that limit.

Solutions are to normalize the table, or convert some fields to Memo fields.

回答3:

Maybe is too late, but i solved this problem compacting/reparing the database file