I have created a database that, at one time, had 1 long
table (approaching 200 fields). I subsequently broke
that table into 3 smaller tables (the largest table still
contains approx. 140 fields).
I do not have a problem writing updates to the smaller
tables, but get the following error when attempting to
update the larger table:
Microsoft OLE DB Provider for ODBC Drivers
error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] Too many fields
defined.
I have read, here and elsewhere, that a 'Compact and
Repair database' should be run after changing the size of
a table. That has been done several times, but the
problem persists. I created a blank db and imported the
tables into it (on the off-chance that the 'counters' in
the new db would not have been affected by anything done
on the original db), but still get the error.
Help!
Jeff Boyce - 21 Jan 2004 21:08 GMT
Just a random thought... do you have any/many "lookup"-type fields defined?
They may be generating (hidden) index fields. Do you have any relationships
defined?

Signature
Good luck
Jeff Boyce
<Access MVP
GCR - 22 Jan 2004 04:01 GMT
>-----Original Message-----
>Just a random thought... do you have any/many "lookup"-type fields defined?
>They may be generating (hidden) index fields. Do you have any relationships
>defined?
Jeff:
Thanks for the response. I have checked my Access db and
there are no lookup fields or relationships. Any other
ideas would be appreciated. Thanks.
>.