"Property value is too large."

[Vincdc]

Hello,
I designed a table with 225 fields and saved without problem. Right now, I
am creating a form using that table. However, when I want to make some
changes in the table (e.g. change a text field to a Yes/No field), I got
error messages of "Property value is too large"; or sometimes it shows "Too
many fields..."
So I cannot make any changes for the existing table. Could anyone give me
some suggestions on this issue?
Thanks in advance!

 

[John W. Vinson]

Hi John,
Yes, this is a very large questionnaire. I have gone through the
normalization process and moved redundant fields into other tables. Right
now, fields in this main table are "one-to-one relationship" and there is no
need to separate them into different tables, unless you suggest to do that to
improve performance.
I also tried to compact the database and it does not work either. I still
got the error message. However, I found that Access saved the changes I made.
It is kind of weird, no idea on it.

Seriously:

Your table design IS WRONG.

It is perfectly straightforward to design a questionnaire database with ten
questions, 200 questions, or 2000 questions...

*with no table having more than six fields*.

With your "one field per question" design, if you ever need to add, change,
delete, or reorder a question, you must restructure your table, revise all
your queries, revise all your forms, revise all your reports.

With a normalized design you add, delete, or edit one record in a table.

Do look at At Your Survey. It's a great app, and it will make your life MUCH
EASIER.

 

[Vincdc]

I see what you mean.
Thanks!

Seriously:

Your table design IS WRONG.

It is perfectly straightforward to design a questionnaire database with ten
questions, 200 questions, or 2000 questions...

*with no table having more than six fields*.

With your "one field per question" design, if you ever need to add, change,
delete, or reorder a question, you must restructure your table, revise all
your queries, revise all your forms, revise all your reports.

With a normalized design you add, delete, or edit one record in a table.

Do look at At Your Survey. It's a great app, and it will make your life MUCH
EASIER.