Hi all<BR>I'm writing (updating) stuff to a database but I get an error message stating that "The operation requested by the application is not allowed if the object is closed"<BR>I've narrowed it down to the SQL statement. "Select * FROM UsersTable" works fine. The moment I add the WHERE UserID= " & UserID,_ then the error occurs<BR> I have done this before and it worked and I've even copied the same update recordset alongside the offending code. And my code seems fine. What am I missing here?<BR>Thanks.