I've been experimenting with ADO transactions under Access and am
having some difficulty figuring out what is happening. Please see the
sample code below:
.....
cn.BeginTrans
rs.Filter = "MasterId = " & 108 & " AND Location = " & 1
If (rs.EOF) Then
Debug.Print "Could not locate MasterId"
GoTo Exit_TestIt
Else
rs("Quantity") = rs("Quantity") - 1
rs.Update
End If
rs.Filter = adFilterNone
cn.RollbackTrans
'PROBLEM HERE
rs.Filter = "MasterId = " & 108 & " AND Location = " & 1
Debug.Print rs("Quantity")
.....
After rolling back the transaction and applying the filter again,
Access generates an error on the last debug.print statement. It
claims that EOF has been reached on the recordset, rs. Why? What has
happened to the recordset such that I can no longer filter for the
item I did previously? Thank you for your help.
Vincent