I have been searching everywhere to find out how I can save a picture from a PictureBox into SQL. Someone told me the best way to do it, is to convert it to a binary file and save it like that.
This is what I have, it probably makes no sense
SavePicture Picture1.Picture, "C:\MyPict.bmp"
strSQL = "Select * from tblError"
RS.CursorLocation = adUseClient
RS.Open strSQL, CONN, adOpenStatic, adLockOptimistic
Set strStream = New ADODB.Stream
strStream.Type = adTypeBinary
RS.Fields("Picture").value = strStream.Read ---> this is where I get an error
Can someone plaese advise, I am running out of advil....