I have a table that has an ole object field. This field stores a picture that can be imported from the VB 2008 front end and also deleted from the front end.
The Backend is a MS Access db.
I have everything working except the correct sql syntax to set the ole object field in the Access database to nothing when a user deletes the picture.
What is the correct syntax? Please provide an example and not a link. My IE crashes everytime I click on a link.
Private Function RemovePicture() As Integer
Dim oC As New OleDbCommand
Dim i As Integer
oC = oleCnn.CreateCommand
###### The update syntax below is what I need help on.
oC.CommandText = "Update Cars Set CarPic = nothing where carid = " & miCarID & ""
i = oC.ExecuteNonQuery()
Catch ex As Exception
If i > 0 Then