• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 846
  • Last Modified:

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?
0
gigifarrow
Asked:
gigifarrow
2 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
0
 
IrogSintaCommented:
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.
0
 
Dale FyeCommented:
take a look at this:  http://www.rogersaccesslibrary.com/forum/topic3.html

for an example of a good survey/questionnaire database.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Rey Obrero (Capricorn1)Commented:
see this link for converting your large table into a relational table

http://support.microsoft.com/?kbid=209493
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I suggest you look at the link fyed supplied. Both Roger and Duane are Access MVP's ...

mx
0
 
Jeffrey CoachmanCommented:
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
0
 
gigifarrowAuthor Commented:
Jeff, I guess  my question is "How do I design a questionnaire database with more than 255 questions"?

;-)
0
 
Jeffrey CoachmanCommented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now