asked on

Having More Than 255 Fields in a Table in ACCESS.

Hello All, I need some help and suggestions. I am making a questionaire with more than 255 fields in the table. I dont want to make two tables. Is there anyway around this?

Jim Horn

I have dibs on 'No' as the answer.
A second table with a 1:1 relationship is your only option.
http://sql-troubles.blogspot.com/2010/10/limitations-of-ms-access-database.html

IrogSinta

If you have a large numberof questions, having a field for each question is poor design. You really should have 1 table that has your questions in one field along with an ID field, and then another table identifyIng who answered the question, the question ID, and their answer.

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

I suggest you look at the link fyed supplied. Both Roger and Duane are Access MVP's ...

mx

Jeffrey Coachman

Is your question:
"Can I have more than 255 fields in a table"

Or is your real question:
"How do I design a questionnaire database with more than 255 questions"?

;-)

JeffCoachman

gigifarrow

ASKER

Jeff, I guess my question is "How do I design a questionnaire database with more than 255 questions"?

;-)

Jeffrey Coachman

A basic Survey/questionnaire DB might be structure something like this:

tblSurvey
sID
sDate
sPerson
...etc

tblQuestions
qID
qText

tblQuestionAnswer
qaID
sID
qID
qaAnswer

But see the links the other Experts posted...
More specific info there...
;-)

JeffCoachman