Too may fields defined

[flip_33_]

Hi All...

I'm building an access database and it currently has 86 fields n one table...It used to have heaps more and it worked fine...Now all the sudden i'm getting a message saying too many fields defined...How do i fix it...

 

[Ziggy]

Give a list of your fields, you may be using fields that would be better suited in a separate table based on Proper database principles.


Ziggy

 

[Jax]

Hi Flip
I believe you can only have 256 fields, have run into this myself, can't remember exactly why they can still seem to be there even after you've deleted them, easiest fix of course is just to make youself a new table with the fields you now want.
Regards Jax