Yep, 255 fields per table. Think about normalising your database structure or at the very least splitting it across two tables. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of fatih_zeren1962 Sent: 07 July 2005 10:56 To: [email protected] Subject: [AspClassicAnyQuestionIsOk] Accsess database 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 ________________________________ 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/
