Record too large error

[ragpatil]

Hi,

I am inserting a record whose length is greater than 2000 characters, its giving error Record too large.I googled, found out that Ms Access allows only 2000 characters in a record.



The work around was to normalize the table, but I need a workaround where we should not divide the table.

[RuralGuy]

Memo fields do not have that limitation.

[ragpatil]

Memo fields do not have that limitation.

Thanks for the reply,
I am having 254 columns in my table, So how many columns can I decalre with type as Memo.

[ragpatil]

Thanks for the reply,
I am having 254 columns in my table, So how many columns can I decalre with type as Memo

[RuralGuy]

254 Columns??? You may wish to do some research on Normalization first. I would be *very* surprised if 254 fields didn't violate at least a few Normalization rules.

[ragpatil]

All the columns are of Text datatype,Can we create multiple tables and create view ,so that it will not affect our normal flow

[RuralGuy]

I'm not sure I understand your "normal flow" but I suspect the answer is yes.