Strange Access error when entering data

[perlfan]

Hi - I have an Access table with already 150 columns. Now I am getting the error message "record too big" (?!) (German: Datensatz zu groß) when I try to enter data. All fields are formatted as text.

The upper two of the 6 rows are quite full of data and the error message pops only up when I try to enter data in the first two rows. Does somebody have a solution? For me the error seems very strange without any good reason as the message appears also when I type in only one character.

Thanks for help in advance - FRANK

 

[jdraw]

A table with 150 columns is extremely unusual. Have you normalized your data?
Can you give us a brief overview of what this table represents? What are the 150 columns for? You may have a proper design, but it seems quite rare.

 

[perlfan]

OK - apparently I didn't have a porpoer design. Tables should rather expand vertically than horizontally. Thx - FRANK

 

[Pat Hartman]

Records are limited to 4,000 characters (search Access help for "specifications" or "limits" for details) when unicode compression is set to Yes.

As has already been mentioned, it is quite likely that your table looks like a spreadsheet which grows sideways. Do some research on normalization which will help you remove repeating groups which are the most likely culprit.