do queries have same number of fields limitation

  • Thread starter Thread starter msmcnewsxp
  • Start date Start date
M

msmcnewsxp

do queries have the same limitation as tables of 255 fields.

how can one-to-one tables to join to form one record source if too many
fields?

need quick answer.

thanks,
mcnews
 
do queries have the same limitation as tables of 255 fields.
Yes.

how can one-to-one tables to join to form one record source if too many
fields?
Click to expand...

You can't.
need quick answer.
Click to expand...

It's not the one you're hoping for, I'm sure, but that's the answer. A
Recordset can have 255 fields, no more, and there is no way around
this limitation.

Could you describe the BUSINESS PROBLEM that you are trying to solve?
I have never yet seen a valid Entity with 255 discrete, nonrepeating,
atomic attributes!
 
Could you describe the BUSINESS PROBLEM that you are trying to solve?
I have never yet seen a valid Entity with 255 discrete, nonrepeating,
atomic attributes!
Click to expand...

this is a field survey for a disease/outbreak study.
the data always ends up being used in a program called SAS which likes data
in a flat file format.
the interface mirrors a hard copy questionaire.
using a normalized database only complicates and slows down the analysis
process.
all of these surveys are last minute cobbled together.
we're lucky to get people to use even this good in these situations.
so sorry to go against the grain here but trial and error has proven this
out.
 
i'm not there to assemble the data.
analysts want to be able to run queries on the data in the field usually 3rd
world countries and other remote locations.
very few epidemiologists are savvy query builders.

this is an old problem.
even getting these people to use access is a large step forward.
 
Back
Top