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