Posted on: 5/16/2011 8:45:30 AM | Views : 248

Hi,
I have MSAccess as front-end application and SQL Server as the database. I need to update a column of varbinary datatype using the MSAccess application.
The below is the code snippet i work on:
===============================================================================================
If StrComp(Nz(rsDst!destination_column, ""), Nz(rsSrc!source_column, ""), vbBinaryCompare) <> 0 Then             strSQL = "UPDATE tablename SET " & _                    "destination_column = '" & Nz(rsSrc!source_column, "") & "'" & _                    "WHERE case_party.file_id= " & rsSrc!file_id & " ...

Go to the complete details ...