If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
access 97
Does anyone know why I would get an error in my access
database when I try to add a column, "TOO MANY FIELDS DEFINED"??? |
#2
|
|||
|
|||
On Thu, 2 Sep 2004 08:08:22 -0700, "cmcgin"
wrote: Does anyone know why I would get an error in my access database when I try to add a column, "TOO MANY FIELDS DEFINED"??? There is a limit of 255 fields in any table - and changing the definition of a field 'uses up' one of these slots. If you have been making lots of changes to field definitions, you can use Tools... Database Utilities... Compact to recover the "lost" entries. If you are trying to create a table with 255 or more fields - stop! I've needed as many as sixty fields, twice in the past twenty years of relational database design. I cannot imagine a properly normalized table with that many fields. John W. Vinson[MVP] (no longer chatting for now) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Accessing a databse thru a webpage (newbie question) | Chang | General Discussion | 1 | August 23rd, 2004 09:10 AM |
Data from Excel to Access | Database Design | 2 | August 20th, 2004 12:53 PM | |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Recommendations needed for installation order of Access XP, Access XP runtime, ... | Mark Plantenberg | Setup, Installing & Configuration | 0 | June 11th, 2004 11:22 PM |