What is/are the sql string you're using? Remember that unless there is a recordset generated (that actually has rows; a recordset that has EOF and BOF true is a closed recordset), you don't need to explicitly close it. --What I do in that closeConnection() routine is usually throw On Error Resume Next in there so I don't have to worry about it in cases where the recordset isn't open.... sgd -- work: http://www.ti3.com/ non: http://thinksafely.org/ > -----Original Message----- > From: Andrew Martin [mailto:comitque at hotmail.com] > > > I keep getting an error when I try to modify a record in my > database. The > update, delete, or add all work; the changes get made, > however, I still get > this error: > " ADODB.Recordset error '800a0e78' > > The operation requested by the application is not allowed if > the object is > closed. > > /preload.asp, line 47 "