FN-FORUM: urgent Acccess problem

date posted 27th January 2007 17:00

I am getting

Type mismatch

on this statement

rs.Open "SELECT Id FROM Product_Images where Product_Id = " & Product_Id & "
and Thumbnail = " & Jpegthumb.Binary & " and Image = " & Jpeg.Binary & " and
Status = '" & Status & "'",cn,adopenkeyset,adLockReadOnly


The bit taht is causing the problem is

& " and Thumbnail = " & Jpegthumb.Binary & " and Image = " & Jpeg.Binary



How do you compare OLE Object fields or how do you find the Id of the record
in Access that you have just inserted otherwise?



Pam