G
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!
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!