Microsoft OLE DB Provider for SQL Server error '80040e14'

I am trying to add data from a form with 8 text boxes.
Each text box needs to allow atleast 2000 characters to be
entered. When trying to save this data to a record in my
database I get the following error: Microsoft OLE DB
Provider for SQL Server error '80040e14' Cannot create a
row of size 8858 which is greater than the allowable
maximum of 8060.
Is there a way around this?
Thanks."Chris" <christopherhebrard@.hotmail.com> wrote in message
news:046e01c39f45$63a6a010$a401280a@.phx.gbl...
> I am trying to add data from a form with 8 text boxes.
> Each text box needs to allow atleast 2000 characters to be
> entered. When trying to save this data to a record in my
> database I get the following error: Microsoft OLE DB
> Provider for SQL Server error '80040e14' Cannot create a
> row of size 8858 which is greater than the allowable
> maximum of 8060.
>
8060 is the maximum row size for any table in SQLServer. You can
-use TEXT instead of VARCHAR columns (TEXT data is not stored on the row).
-break your table into multiple tables and spread out your varchar columns.
David|||Thanks for your help, very much apreciated. Its funny that
I spent about an hour researching this problem, and all I
had to do was try the text type. :)
>--Original Message--
>"Chris" <christopherhebrard@.hotmail.com> wrote in message
>news:046e01c39f45$63a6a010$a401280a@.phx.gbl...
>> I am trying to add data from a form with 8 text boxes.
>> Each text box needs to allow atleast 2000 characters to
be
>> entered. When trying to save this data to a record in
my
>> database I get the following error: Microsoft OLE DB
>> Provider for SQL Server error '80040e14' Cannot create a
>> row of size 8858 which is greater than the allowable
>> maximum of 8060.
>8060 is the maximum row size for any table in SQLServer.
You can
>-use TEXT instead of VARCHAR columns (TEXT data is not
stored on the row).
>-break your table into multiple tables and spread out
your varchar columns.
>David
>
>.
>