By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,647 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Table Fields max

P: n/a
I am creating an Access 2000 database with a Web Front end that will
have around 150 questions with 148 questions having just one number
input (which will either be a 1 or a 2 or a 3 or a 4 or a 5). All 148
questions will be short sentences such as:

Question Choose One Number Rating
1-How would you rate Red Rock1? 1 2 3 4 5
2-How would you rate Red Rock2? 1 2 3 4 5
3-How would you rate Red Rock3? 1 2 3 4 5
4-How would you rate Blue Rock1? 1 2 3 4 5
5-How would you rate Blue Rock2? 1 2 3 4 5
6-How would you rate Blue Rock3? 1 2 3 4 5
etc...

The 6 above examples show just 6 (redRock1, redRock2, redRock3,
blueRock1, blueRock2, blueRock3) out of the 148 fields.

The other two fields will have a 100 character input and 250 character
max input.

I will have three other tables similiar to this table (with each table
having 150 fields (148 single number input fields and 2 fields limited
text under 250 characters).

There will be around 800 people taking this questionaire survey over a
2 week timeline where it takes around 20 minutes to complete after
which time the user will submit the information into the 4 tables.
Please advise if Access can it handle 150 fields per table and
everything I want to do?

Dec 1 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<te****@hotmail.comwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
>I am creating an Access 2000 database with a Web Front end that will
have around 150 questions with 148 questions having just one number
input (which will either be a 1 or a 2 or a 3 or a 4 or a 5). All 148
questions will be short sentences such as:

Question Choose One Number Rating
1-How would you rate Red Rock1? 1 2 3 4 5
2-How would you rate Red Rock2? 1 2 3 4 5
3-How would you rate Red Rock3? 1 2 3 4 5
4-How would you rate Blue Rock1? 1 2 3 4 5
5-How would you rate Blue Rock2? 1 2 3 4 5
6-How would you rate Blue Rock3? 1 2 3 4 5
etc...

The 6 above examples show just 6 (redRock1, redRock2, redRock3,
blueRock1, blueRock2, blueRock3) out of the 148 fields.

The other two fields will have a 100 character input and 250 character
max input.

I will have three other tables similiar to this table (with each table
having 150 fields (148 single number input fields and 2 fields limited
text under 250 characters).

There will be around 800 people taking this questionaire survey over a
2 week timeline where it takes around 20 minutes to complete after
which time the user will submit the information into the 4 tables.
Please advise if Access can it handle 150 fields per table and
everything I want to do?
Better to structure your tables so each question is a ROW rather than a COLUMN.
It does make the interface a bit more challenging, but that design is a LOT more
flexible.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 1 '06 #2

P: n/a
Better to structure your tables so each question is a ROW rather than a COLUMN.
It does make the interface a bit more challenging, but that design is a LOT more
flexible.
Thanks,

Please advise what you mean by the design being more flexible if I keep
my table columns at 150 fields?
I actually have 3 tables with 150 fields in each one and one
Demographic table that ties each survey with a Demographic id.

I currently have my web Front end interface working very well with the
150 wide one table insert on my Access 2000 database. The records
currently insert very quickly but still wondering what issues I will
have if I keep the 3 tables at 150 column wide?? I am looking at
about 800 Survey inputs for this database over a 2 week period and then
close the survey and start doing reports off the database results.

Dec 3 '06 #3

P: n/a
te****@hotmail.com wrote in
news:11**********************@73g2000cwn.googlegro ups.com:
>Better to structure your tables so each question is a ROW
rather than a COLUMN. It does make the interface a bit more
challenging, but that design is a LOT more flexible.
Thanks,

Please advise what you mean by the design being more flexible
if I keep my table columns at 150 fields?
I actually have 3 tables with 150 fields in each one and one
Demographic table that ties each survey with a Demographic id.
You want a survey results table with 5 columns
SurVeyID,RespondentID,QuestionID,AnswerNo and AnswerText

The answers each get their own row.

To go with that, you will need a few other small tables

Survey: which contains an ID, and description about what the
survey is on, customer.,dates etc.

Respondent: again an ID, respondent Info as required.

Questions: this has SurveyId, QuestionID and QuestionText.One
question per row.
>
I currently have my web Front end interface working very well
with the 150 wide one table insert on my Access 2000 database.
The records currently insert very quickly but still
wondering what issues I will have if I keep the 3 tables at
150 column wide?? I am looking at about 800 Survey inputs
for this database over a 2 week period and then close the
survey and start doing reports off the database results.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Dec 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.