Error message - Too Many Fields Defined

[Guest]

Why is this suddenly poping up after using this database for 2 years? What
could be causing it?

I get this error message when I attempt to change the format of a field from
text to date/time

 

[Rick Brandt]

Why is this suddenly poping up after using this database for 2 years?
What could be causing it?

I get this error message when I attempt to change the format of a
field from text to date/time

The limit of 255 fields is a "lifetime limit" and changing a field is actually
done in the background by creating a new field, copying the data, and then
deleting the old one. Try changing the name of the table, compacting the file,
and then changing the name back.

You can also get that error if the total (data) size for a row exceeds 2KB. You
might have been just under that threshold before attempting to change the
DataType.

 

[Guest]

You can also get this message for a crosstab query if you pick a field for
column that has a large result. Like if you were putting 1000 employees as
column names.