Hi,
I have a problem with an edited image field. I am using a pass through query and retrieving records from a SQL Server 2005 express database. I retrieve the record and store it in a local access database successfully. But when the image field is edited (for example, a bitmap image data type- I am actually capturing a signature) I try to update a record in the SQL Server database with an image field of type varbinary(MAX). When I build the pass through query, the sql string stops at the Graphic field- it seems to run out of room. The actual value of the image field is:
tbl_WorkOrder.[graphic] = /. I don't know what these symbols mean or what value the field should be.
Any help would be greatly appreciated.
Thanks Frank Srebot
Start Free Trial