Update statement not working?

[mrdutchie]

I'm stuck with my update statement for a access2000 file.

I have a table called email with 2 fields. (name and email)
I can Add to it just fine, but I can't update.
This is what I have

in my access table I have

Name Email
perry [email protected]
peter [email protected]



value1 = "newname"
Dim mycn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/donation.mdb")

Dim mycmd As OleDbCommand = New OleDbCommand
mycmd.Connection = mycn
mycmd.CommandText = "UPDATE email SET name=value1 WHERE name='perry' AND email='[email protected]')"
mycn.Open()
mycmd.ExecuteNonQuery()
mycn.Close()

it will fail on mycmd.ExecuteNonQuery()

What am I doing wrong?

[Cander]

Basic string concantenation

mycmd.CommandText = "UPDATE email SET name='" & value1 & "' WHERE name='perry' AND email='[email protected]')"

[mrdutchie]

changed it to

mycmd.CommandText = "UPDATE email SET name='hello' WHERE name='perry' AND email='[email protected]'"

and still not working.

[Cander]

what error?

[mrdutchie]

Object reference not set to an instance of an object

in this line

mycon.UpdateCommand.CommandText = "UPDATE email SET name='hello' WHERE name='perry' AND email='[email protected]'"

[mrdutchie]

please forget my last comment.
It's working now...
forgot that "[email protected]" was not in the database. duh....

Thanks so much for helping me out.