MS Access Too Many fields during UPDATE

When I try to UPDATE a table in MS Access, it g开发者_JAVA百科ives and error saying too many fields defined. I googled and saw that i need to Repair and Compact, which I did, but still does not work?

Anyone has any ideas? Also, what actually count towards the "too many field" counter?

Thanks.

I seem to have found the answer:

The Microsoft Jet database engine has an internal limit of 255 fields per query. As the Microsoft Jet database engine iterates through the records in an update query, it creates a field for the original value and a field for the updated value. When more than 127 fields are selected, it reaches the 255 field limit of a query.

Consider the following SQL for an update query: UPDATE Table SET A=B, C=D Internally the query looks as follows: SELECT A,B,C,D FROM Table

-- http://support.microsoft.com/kb/199076

You have ~140 fields, do you not?

Have you tried splitting the UPDATE query up across perhaps a few? Perhaps chunk it out to two or three - verifying each took before proceeding with the next? Could help toward your 'Too many fields' problem, and allow you to debug problems easier? Just a thought, your mileage may vary.