Update/change Database field...

[CCG3]

I am working with VB.Net 2005 and I am looking at an Access 2003 database. What I need to do is open the database, look for a certain value (coming from text box 1) in a certain table (APCHK) and every one of them with that value replace/update with a different specified value (coming from text box 2),then close the database. What would be the best way to do this? Thanks for any advice you can give me with this.

[Lost User]

In very liberal psuedocode:

OpenDatabase()
ExecuteSQL("Update APCHK Set ColumnName = '" & TextBox2.Text & "' Where ColumnName = '" & TestBox1.Text & "'")
CloseDatabase()

Is that what you are trying to accomplish?