Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Increasing the default number of fields in a table/query
- Thread starter nqobile
- Start date
Nope.
If you really need more fields to store data, you'll have to create two tables and set a 1-to-1 relationship between them.
But you cannot retrieve more than 255 fields in a query.
Sad, but true. I have never needed such a number of fields, but I don't like limitations...and this is one of them.
Dan
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
If you really need more fields to store data, you'll have to create two tables and set a 1-to-1 relationship between them.
But you cannot retrieve more than 255 fields in a query.
Sad, but true. I have never needed such a number of fields, but I don't like limitations...and this is one of them.
Dan
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question