Databases

[SteveD73]

Hello

How can I delete a record from a recordset. Im using an Access database. I open it like this.


adOpenForwardOnly = 0
adLockReadOnly = 1
adCmdTable = 2
nCount = 0

Set objConn = Server.CreateObject("ADODB.Connection&quot
Set objRS = Server.CreateObject("ADODB.Recordset&quot

objConn.Open strConnect

objRS.Open "Users", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable


thanks

 

[dianal]

MSDN says:
adLockReadOnly = 1 Indicates read-only records. You cannot alter the data.
Try using instead of it:
adLockOptimistic = 3 Indicates optimistic locking, record by record. The provider uses optimistic locking, locking records only when you call the Update method.