Table size error message

[GCR]

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]

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?

 

[GCR]

-----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?


--
Good luck

Jeff Boyce
<Access MVP>

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.