Hello, I have a DataGrid1 hooked up to adodc1, and an access file connected with adodc1 through settings (not code). The problem is when I delete a row from the middle of DataGrid1 using a DblClick on that row .. the row goes away just fine -which is what I want-, but when I hit the CmdLog button to log a new entry from the end of the DataGrid .. all rows after where the DblClick was disappear. My database is Access 2003, and I am working on VB6.


Two Questions:

1- How to delete a row from the middle of the DataGrid1, and get the rows before & after it stitched together?
2- Is there a way to make the data saved all at once upon an event i.e., button click or closing the program?

Here is my code

Code:
 Private Sub DataGrid1_DblClick()

On Error GoTo Rora

DataGrid1.Refresh
Adodc1.Recordset.Delete
Adodc1.Refresh
Adodc1.Recordset.Update
'Adodc1.Recordset.Refresh

Rora:
Exit Sub

End Sub

Private Sub CmdLog_Click()

Adodc1.Refresh
Adodc1.Recordset.AddNew
DataGrid1.Columns(0) = Variable
DataGrid1.Columns(1) = Variable1
DataGrid1.Columns(2) = Variable2
DataGrid1.Columns(3) = Variable3
DataGrid1.Columns(4) = Variable4
DataGrid1.Columns(5) = Variable5
DataGrid1.Columns(6) = Variable6
Adodc1.Recordset.MoveLast

End Sub