Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2004

Tip: Looking for answers? Try searching our database.

Table size error message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GCR - 21 Jan 2004 16:41 GMT
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.
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.