update not working with an access db

[mwhalen]

I have 2 forms - one to add a new item and one to approve an existing item (basically to query and then to update). I'm having a terrible time trying to get the update to work. Here is the message I get:

"Cannot bind to property of column (name) on datasource".

Any thoughts?

 

[jebenson]

Do you have a column called 'name' in your table? If so, that my be your problem, as 'name' is (I believe) a reserved keyword in Access.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[mwhalen]

the column is not called name, that was more of a generic label. The column is called "approved by

 

[chrissie1]

a bit of your code would help.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[mwhalen]

Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
If OleDbConnection1.State = ConnectionState.Closed Then
OleDbConnection1.Open()
End If
OleDbDataAdapter1.SelectCommand.Parameters("CLIENT_KEY").Value = txtClientKey.Text
OleDbDataAdapter1.SelectCommand.Parameters("TRACKING_NUM").Value = txtTrackNum.Text
DataSet21.Clear()
OleDbDataAdapter1.Fill(DataSet21)

OleDbConnection1.Close()
Dim objCurrencyManager As CurrencyManager
objCurrencyManager = CType(Me.BindingContext(DataSet21), CurrencyManager)

txtTrackNum.DataBindings.Add("Text", DataSet21, "TRACKING_NUM")
txtSignOffName.DataBindings.Add("Text", DataSet21, "SIGNED_OFF_BY")
TextBox1.DataBindings.Add("Text", DataSet21, "ADDITIONAL_COMMENTS")
End Sub

 

[chrissie1]

and on wich line you get the error

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[mwhalen]

it just won't update the database