Erroneous "Too Many Fields Defined" Error Message

[jdegeorge]

Hi

I inherited a table that has 207 fields in it. Yes, I know it's approaching the 256 field limit but I can't change the table right now.

What I'm trying to do is change all of the TEXT (10 characters) fields to NUMBER (9 digits, auto decimal) fields.

I'm able to change about 10 of these fields, then on the 11th or so I get the error message and can't continue.

Any ideas why?

Thanks!

Jim DeGeorge (MS Access Programmer)

 

[Golom]

When you are modifying field definitions (say from text to numeric), Access creates temporary fields to do the conversion. If you make some changes and then save the new file definition then go back in and make more changes you should be OK. You should also note that the limit is actually (Field Count + Index Count) cannot exceed 255.

 

[jdegeorge]

I compacted the database and the field counter was reset. Thanks!

Jim DeGeorge (MS Access Programmer)