Creo que no entendi bien :
Código:
on error resume next
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Access_STRING
Recordset1.Source = "SELECT * FROM tmarios"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
if error.number <> 0 then
estado = "<span class=""verde""> Activo</span>"
else
estado = "<span class=""rojo""> Inactivo</span>"
end if
error.clear