Error: Too many fields defined

[kedarj]

I have a table in which I have about 245 fields (I know they are too much, but cant change the structure).
There are about 4 numeric fields, which have field type as Long Integer. I want to change them to Field type Single.
When I try to change them, I get a message too many fields defined.
What is the solutionß
Can someone suggest?
regards
K

 

[KenHigg]

You may be able to remove a col or two, make the change and then add it back...

 

[kedarj]

I removed five columns, but no success. I get the same error.
What is the other way around?

 

[KenHigg]

Did you compact and repair the db after you removed them?

 

[kedarj]

Yes, I did that now. I was able to add change it. But after the compact it has modified something within the query and I am getting errors on the query..

 

[KenHigg]

Did you add the cols back?

 

[kedarj]

yes i did. but now somethings wrong...I get an error with some other relationships

 

[KenHigg]

You may have zonked some fk's