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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to connect an SQL Table with more than 255 fields???!!!!
- Thread starter pinuz
- Start date
Common issue. I have a system we purchased that has a table with 475 fields. Guess they never heard of normalization.
I know this is a problem in Acc97 and Acc2000. What I do is write pass-through queries and specifiy the fields I want. Basically creating a couple of different queries to span 200 or so fields at a time.
Certianly an issue that I would like to see fixed in the future by MS if not already in XP.
htwh,
Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com
Chester County, PA Residents
Please Show Your Support...
I know this is a problem in Acc97 and Acc2000. What I do is write pass-through queries and specifiy the fields I want. Basically creating a couple of different queries to span 200 or so fields at a time.
Certianly an issue that I would like to see fixed in the future by MS if not already in XP.
htwh,
Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com
Chester County, PA Residents
Please Show Your Support...
MichaelRed
Programmer
not functionally different, but should be faster to create the subsets as VIEWS on the db and just reference the views. Pass through queries are parsed / validated / compiled EACH time they are used by the db, whereas the views -as a part of hte source db are 'pre-compiled".
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question