|
| 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
August 20th, 2008, 05:04 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
"Too many fields defined" error, but don't have 255 fields
I'm receiving a "too many fields defined" error when I try to save my table
design, but I have nowhere near 255 fields. I don't want to have to do all the work over again. Is there any way around this problem? All my fields are only 1 and 2 character length text fields, with only one indexed field. 
|
|
#2
August 20th, 2008, 05:48 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
"Too many fields defined" error, but don't have 255 fields
As you create and delete or rename fields, your field count goes up. You
could try compact your database to release the field count to the actual number of fields. It seems that you might be creating a much un-normalized table. Most of us old-timers suggest that if you have more than about 30 fields, there is something wrong with your structure. Your requirements might call for more fields but this should be very rare. -- Duane Hookom Microsoft Access MVP "daisyd65" wrote: I'm receiving a "too many fields defined" error when I try to save my table design, but I have nowhere near 255 fields. I don't want to have to do all the work over again. Is there any way around this problem? All my fields are only 1 and 2 character length text fields, with only one indexed field.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
