delete records in adodb record set

R

ravindar thati

Hi all, i am using ms access 2003,

i have a form,
i connect to the mysql database using adodb connection.
this works fine.

but when i delete a record, it is deleted but still the record set
shows that record.
when i close the application and again run it, then the record set
dosnt show the delted record.

what could be the problem


my code goes like this
rsInfotable is a adodb record set

i opened the record set with the code


Code: 
str = "select * from infotable;"
rsInfotable.Open str, objConn, adOpenKeyset, adLockOptimistic

Code: 
If txtAutonumber.Visible Then



rsInfotable.Delete


MsgBox ("Record has been successfully Deleted")
rsInfotable.MoveNext


If rsInfotable.EOF And rsInfotable.BOF Then
MsgBox ("No more records")
Call DiableButtons
Exit Sub

ElseIf rsInfotable.EOF Then
rsInfotable.MoveLast
Call DisplayData


End If
End If
 
Top