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 ...