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

[Guest]

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

 

[Guest]

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

 

[tina]

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

 

[John Vinson]

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

You can't, you shouldn't, and there are better ways to do whatever it
is you're trying to accomplish!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[david epsom dot com dot au]

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

 

[Jeff Boyce]

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

Jeff Boyce
<Access MVP>

 

[david epsom dot com dot au]

So, David, your "row number" is actually a RecordNumberFromTheOldData

i really recommend you read up on table normalization,
and

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

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

(david)