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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Working outlook via vba code with xlsx - error 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Remove Identical words 0
Prompt For Replace in Selection And More... 0
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Modifying/Appending Record Between Subforms 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top