On addtonews.htm, I have 1 text box that is filled out, and you submit it. It works most of the time, BUT when I write a certain amount of words, this error pops up:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/stacygraff/addtonews.asp, line 14

Does anyone understand why this is happening and what I can do about it?

The Code in that line 14 is:

rsAddNews.AddNew
rsAddNews.Fields("NewsInfo") = Request.Form("NewsInfo")
rsAddNews.Update

Maybe the number of chars in Request.Form("NewsInfo") is more than the db field can store?

Is there a way to set it up to where the user can type in the current news (2 or 3 lines) like in a text area? I've used the textarea in the form, but it probably has to do with setting up that field in the database...?

Check here: www.adopenstatic.com/faq/80040e21.asp. Usually caused because you have a field defined of a certain size (eg text(255)), and the user supplies more than this. You need to check this first, and if they've supplied too much, you need to either truncate it -or- tell the user to edit the submission and supply less data.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com