Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

blob Access 2000 DB

Status
Not open for further replies.

Avacha

Technical User
Apr 1, 2002
69
US
Why doesn’t this line of code work?

Do Until RsMath.EOF
CONN.Execute
"UPDATE PhotoBlobTable Set PhotoBlobTable.photo_blob=" & RsMath.Fields(“photo_blob”) & " where PhotoBlobTable.ssn= " & RsMath.Fields("SSN")
RsMath.MoveNext
Loop

PhotoBlobTable.photo_blob and RsMath.Fields(“photo_blob”) is blob
The Photo_blob value is not recognized, and I get this error:
Run-Time error ‘-2147217904(80040e10):’
No value given for one or more required parameters

Thamks for help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top