I think the problem is that there are 300 questions in the questionnaire and each person who fills it out has one row in the database with their answers in. Correct me if I'm wrong. If that's the case, a better way of doing it would be a table for the questions, a table for the respondents, and a table for the answers. The questions table contains the questions and an ID for each of them, so 2 or so fields, the respondents table contains basic information about the respondent, and an ID, and the answers table contains a question ID, respondent ID and an answer for each question and respondent. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Thorne Sent: 07 July 2005 12:51 To: [email protected] Subject: RE: [AspClassicAnyQuestionIsOk] Accsess database I think you need to explain this a bit more... and why are you "across" with your fields when it would be better to go "down"? Andy >From: "fatih_zeren1962" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [AspClassicAnyQuestionIsOk] Accsess database >Date: Thu, 07 Jul 2005 09:55:33 -0000 > >Hi to all, > >Maybe this problem was asked before, but I need urgently help. > >I have a Access database with aprox. 300 fields within one table ( this >is a 300 question formular ). >After the 255 th. field I got an error message that I can not insert >more than 255 fields ( or lines ) into the database. > >Now I am not able to complete my database. > >Is there a limit of datafields in Access ??? > >Thanks, > >Fatih > > _________________________________________________________________ Free blogging with MSN Spaces http://spaces.msn.com/?mkt=nl-be ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
