Hey guys! Blob here with a frustrating code problem.
I have an access database that I am trying to update with some "seemingly" simple VB.Net 2008 code. When I try and run this code it links to the cmd.ExecuteNonQuery() and tells me there is a syntax error in my update and the oledb exception was unhandled. Im sure there might be a quote out of place in the update line, but I simply cannot see it, Any ideas???
CODE
Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Documents and Settings\mike.mcgillivry\My Documents\Visual Studio 2008\Projects\Computer Inventory 2\Computer Inventory 2\MINE-Trouble & Inventory.mdb'")
'User is the column of users that each row has
'temp is the name that I want to change to
'Number is the column with the primary key field in my database
'temp11 is the number that links with Number to be searched
'So im trying to say in this update is that if the primary key is the same as the temp11 number, that is the row I
'would like to update. And in the update I want to put temp into the user column field so that the name is updated.
Dim cmd As System.Data.OleDb.OleDbCommand = conn.CreateCommand()
cmd.CommandText = "UPDATE [Computer Inventory] SET User='" _
& temp & "' WHERE (Number='" & temp11 & "') "
Try
cmd.Connection.Open()
cmd.ExecuteNonQuery()
Finally
cmd.Connection.Close()
End Try
This post has been edited by jayman9: 1 Jul, 2008 - 07:34 PM
1 Jul, 2008 - 11:08 AM
|