How to connect an SQL Table with more than 255 fields???!!!!

[pinuz]

Big problem connecting a SQL table bigger than 255 fields. Do yu know if there are add ins or similar to do the job?

 

[smedvid]

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

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[MichaelRed]

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