Database Discussion - Error in row

Print Page | Close Window

Error in row

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2469
Printed Date: 29 March 2026 at 8:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error in row

Posted By: ultramods
Subject: Error in row
Date Posted: 06 May 2003 at 2:01pm

can anyone help please. i keep getting the following error when trying to enter data into an emptuy table.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]Error in row

/ultramods/carpics/postCarPicReview.asp, line 26

'sql = "SELECT * FROM carPicReviews"
Set rs = Server.CreateObject("ADODB.recordSet")
rs.Open "carPicreviews", conn, 3, 3

rs.AddNew

rs("AuthorID") = authorID
rs("groupName") = groupName
rs("message") = message

rs.Update 'error on this line

rs.Requery

rs.close
set rs = nothing
conn.close
set conn = nothing

thanks for any help.

Replies:

Posted By: ultramods
Date Posted: 06 May 2003 at 2:23pm

Found the answer. groupName was empty