I need to be able to use object.recordcount in my code. Can I do this without creating a recordset object, maybe using the second line of code that is below? If so how? If I need to create a recordset object then I need to set the commandtimeout option if possible, otherwise my code times out. I need to create a recordset such as below:<BR><BR>set srchldsrs=Server.CreateObject("adodb.Recordset")<B R>srchldsrs.open mySQL,DSN,adopenstatic<BR><BR><BR>I am currently using this:<BR><BR>set repconn=server.createobject("adodb.connection")<BR >repConn.CommandTimeout = 600<BR>set reprs=repconn.execute(mySQL)<BR><BR>I need to know how I can set the commandTimeout using the recordset code, set srchldsrs=Server.CreateObject("adodb.Recordset"). Or I need to know how I can use adopenstatic with the, set repconn=server.createobject("adodb.connection") code. Thanks in advance.<BR><BR>Eric