Max Fields on a Table ??????

P

PhilipBenno

I have 235 Fields on one table when I try to add any more and come to save
this table I get a error message saying Too Many Fields Defined, I need to
Create another 15, is this possible or how do I get round the problem ??
 
N

Nikos Yannacopoulos

Philip,

If you look up Access Specifications in help you will see that the max.
number of fields in a table is 255. If you need more, then the solution
is to divide them between two tables, joined by a common primary key, so
there is a one-to-one relationship between them.
I have to say, though, that it is quite unusuakl that so many fields are
required in a table. Any chance your data are not normalized?

HTH,
Nikos
 
S

Steve Schapel

Philip,

Try Compact the database (via the Tools|Database Utilities menu).

Having said that, the need to have this many fields in a table is almost
certainly a sign that your database design could be improved, and you
may want to seek some advice or help with this aspect.
 
P

PhilipBenno

Hello Nikos

Thanks for your reply if i could add 255 that would be enough for that
table,any ideas why i can't add above 235
 
P

PhilipBenno

Hello Steve

Thanks for Info , Compacted the database and repaired it,Now I can add the
full 255
fields,its a metallurgical database examining spring properties.
 
L

Larry Daugherty

And a single spring has 255 attributes?

I suggest that you read up on Normalization. It would also be useful
to lurk microsoft.public.access.tablesdesign

HTH
 
Top