Advertisement

06.26.2008 at 05:42PM PDT, ID: 23520323
[x]
Attachment Details

How do you update a varbinary(MAX) field (SQL Image field) after editing it in MS Access Front end by using a Pass Through Query?

Asked by fsrebot in MS SQL Server, SQL Server 2005, Access Coding/Macros

Tags: Microsoft, MS access 2002

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
[+][-]06.27.2008 at 04:37AM PDT, ID: 21882605

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Server 2005, Access Coding/Macros
Tags: Microsoft, MS access 2002
Sign Up Now!
Solution Provided By: Rick_Rickards
Participating Experts: 1
Solution Grade: B
 
 
[+][-]07.04.2008 at 07:47AM PDT, ID: 21933394

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628