[RESOLVED] Dataset New Row

[mouse88]

Here is the code i am using to add a new row and update the database:

Dim DataSetNewRow As DataRow

        DataSetNewRow = Database.DataSet.Tables("Policies").NewRow
        DataSetNewRow.Item(1) = PolicyNumberTextbox.Text
        DataSetNewRow.Item(2) = BrokerTextbox.Text
        
        Database.DataSet.Tables("Policies").Rows.Add(DataSetNewRow)

        DataAdapter.Update(Database.DataSet, "Policies")

The part highlighted in red returns the follwoing error but i cant understand why as this is the code ive used in a few other apps.

[mouse88]

Nevermind problem solved. I had a space in my table name in Access so i took that out and solved the problem