How can I do more than one update to a database? I am using this statement to update one record:<BR><BR>qUpdate.open "UPDATE StCodes SET Code='" & Request(code) & "', Description='" & Request(desc) & "', Type='" & Request(typ) &"'"<BR><BR>I have set qUpdate and conn is the database connection (I know I did this right because it is used exactly like this elsewhere and works). Right now I just do it in a loop and end up with the following error:<BR><BR>Operation is not allowed on an object referencing a closed or invalid connection.<BR><BR>I assume I get this the secound time threw when I am trying to write to the database a secound time using a bad object. I tried moving the Set comand inside the loop my idea in doing this was that is would be set to a new Recordset Object each time but this did not do it. What can I do to get this to work. I checked the database FAQ's but did not see anything in there so any help would be apreciated.