Too Many Fields 2

[cabobound]

I have a very large table that I am trying to edit a record on. The error Im getting is "Too Many Fields Defined". Is there a limit as to how many fields you can update at one time?

[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.

Thanks.

Keith

 

[Chopstik]

Interesting... Not something I was aware of, but then again, I don't use Access in this manner, either...

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

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[cabobound]

gotta love MS.

 

[Chopstik]

Well, can't say too much since they keep me employed (in the sense of I use their products, not that I work directly for them)... But, that being said, there are times I have wondered?...

;-)

------------------------------------------------------------------------------------------------------------------------
"As for the bureacratic, politically-correct, mollycoddling, asinine, Romper Room antics of...clients and management, just read up on Dilbert. It's not funny - it's a training manual."
- Mike

 

[worldwise]

Access keeps an internal count of total number of fields in a table and has a
limit of 255 fields per table. Each time you modify a field or add a field,
this count increases by 1. When you delete a field, Access does NOT reset this
counter. So it's possible for you to have less than 255 fields and still get
this error message.

If your field count is less than 255, just compact the database again which
should reset the internal field count counter.

If you actually have more than 255 columns, you can probably create two tables
and join them with an INNER JOIN statement based on a common key field.