how do I add more than 255 fields to my table?

  • Thread starter Thread starter Guest
  • Start date Start date
You can't.
What you can do is to create a second table to store the extra fields. Just
make sure that the second table has the same primary key field(s) as the
first.
If you want to have all the fields from both tables on a form, use a linked
subform for the second table
 
if you have 255 fields in one table, it's very likely that your table is not
normalized. most experienced developers I've seen address this issue say
that a reasonable upper limit for a properly normalized table is around
25-30 fields. i really recommend you read up on table normalization,
otherwise you're going to have a terrible time trying to manage that much
data, and a lot of difficulty trying to leverage the power of the Access
software.

hth
 
Store the table sideways:
put each field name into a new record like this:

row number, field name, value.
1 field1 57
1 field2 #12/12/2004#
1 field3 105
2 field1 57
2 field2 #11/12/2004#
2 field3 106

etc
 
So, David, your "row number" is actually a RecordNumberFromTheOldData
number, right? Otherwise, how did you get 3 row#1's?

Jeff Boyce
<Access MVP>
 
So, David, your "row number" is actually a RecordNumberFromTheOldData

That's right. I see that other posters said:
i really recommend you read up on table normalization,
and

You can't, you shouldn't, and there are better ways to do
Click to expand...

but I wanted to experiment with an alternate form of expression :~)

(david)
 
Back
Top