Using:
MS Access 2010
Visual Studio 2010 with Provider=Microsoft.ACE.OLEDB.12.0 Connection

I have tried multiple ways to do this fought through Concurrency issues
current code gives no errors however when I re Fill DataSet nothing has been removed from database...

Current code for Button1(reload data), Button2(delete row):

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        CustomerTableAdapter.Fill(AutoBillDataSet.Customer)
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim i As Integer
        i = DataGridView1.CurrentRow.Index
        Try
            'DataGridView1.Rows.Remove(DataGridView1.CurrentRow)
            AutoBillDataSet.Customer.Rows(i).BeginEdit()
            AutoBillDataSet.Customer.Rows(i).Delete()
            AutoBillDataSet.Customer.Rows(i).EndEdit()
            AutoBillDataSet.AcceptChanges()
            CustomerTableAdapter.Update(AutoBillDataSet.Customer)
            ''Button1.PerformClick()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

I appreciate any help on this at all.
If you remove the AcceptChanges I get a concurrency violation for Deleted row information cannot be accessed through the row.
I have been pulling my hair out trying to solve this.

I think I found my issue:

When connecting to datasource a window pops up about database not in file and adding to output I redid form and choose no to this and now everything works.

Ty all

This question has already been answered. Start a new discussion instead.