Hi

I have been working on a pretty large database for a while now, and it has been worked over many times.

Just recently, I went into a table, and was trying to modify the properties of a field when I got the error message

"Property value to large"
and then it will not save.

So I can not make any more changes to the database.

I was actually trying to make the field simplier than it was before. I check the other fields and I can't change ANY of them.

I go the imppression that this warning was supposed to mean that one had exceeded the memory limit alocated to any one field, but I don't see how I have done that.
Is it because I have changed things so many times?

What should I do?

Thanks you so ver much!
~desperate

Have you been compacting and repairing on a regular basis (every few hours during construction)? If not, compact and repair. If that does not fix the problem then import everything into a new, blank db and see if that helps.

hth,
Jack

thank you

I have compacted and repaired occasionally, but not as often as every few hours.
I tried that. nothing happened.
I imported everything else into a new database, nothing happened.

Any other suggestions?

I really don't want to have to erase that table and start all over

thank you either way
K

It looks to me like creating a new Table is the only way you are going to find out if that is the problem. You can try copying the table, but it should not take long to rebuild it from scratch. Once you have it working you should be able to copy any data over from the old table to the new one....

hth,
Jack

Hi

I fixed it!
I don't know WHY this worked, but I just went through and changed every text field I had to the maximum number of characters (255) a field can have, and magically it worked.
Maybe this will help someone else some day,
although I have NO idea why it helped.

Cheers, Kelly

I am glad you got it working!