apologies for too many posts fro me
but i need to graps this ado...

Code:
Public Sub LogOffUser(UsrName As String)
    Dim LogOffUserRecord As ADODB.Recordset
    Set LogOffUserRecord = New ADODB.Recordset
    SQL = "SELECT * FROM LoggedUsers WHERE UserName = " & "'" & UsrName & "'"
    LogOffUserRecord.Open SQL, MeterInfo
    LogOffUserRecord.Delete
    Set LogOffUserRecord = Nothing
    End
End Sub
i get error on the logoffuserrecord.DELETE
saying
"object or provider is not capable of performing the operation"

that code should return one record...
and delete it

according to help i read.. .DELETE is default and will delete the current record..

i tried even typing the constants..
still same error..

thanks