Table Field Definition Limitations

[ramsayaj]

Hi there,

I have just defined a large table of 207 fields. Access let me save this okay and I was adding data when I realised I needed to change some of the number field formats. I went back into the table and changed a fields attributes and click "save". I then got a message telling me there are too many fields defined and it will not save my change.

I deleted three fields thinking that might take me below the threshold but despite this I cannot save any amendments to the existing fields as the same message inidicating too many fields are defined keeps popping up when I go to save.

Is there any way around this besides chopping the table into smaller ones and linking them? (I want to avoid this is at all possible)!

Many thanks,
Alan

 

[Rich]

There are solutions to your problem but it sounds as though you have a design problem, do you really need 207 fields in one table?

 

[ramsayaj]

Hi Rich,

Thanks very much for getting back to me. Yes, you are right, I have been pretty stupid with my table design and I apprecaite that searching etc on a table of that size is going to be slow.

I may break the table into smaller chunks further down the road, however for the moment I would be keen to know how I can get round the problem and make amendments to the field attributes - can you help me with that?

Many thanks,
Alan

 

[ramsayaj]

Hi Pat,

Many thanks for the tip - worked a treat. I guess I should look at breaking my table down into more sensible chunks, but I really apprecaite you helping getting me going.

Cheers,
Alan