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
    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
        Catch ex As Exception
        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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.