title: varbinary(max) capture and store OLE image
body: <p>I support an application that has a SQL Server backend and an Access front end.  A signature image is stored in a varbinary(max) column in a table in SQL Server, the Users table.  The value in this field is displayed in various Access reports.<br>
  Periodically, a new User is added to the system.  I have not succeeded in finding a way to perform this task programmatically.  No matter how I load the image into the field in SQL, it will not display in the Access reports.  I have to perform the following steps to get the image loaded and displaying correctly:<br>
  1.  Open Doc.<br>
  2.  Copy signature to clipboard.<br>
  3.  Open Word.<br>
  4.  Paste signature into Word.<br>
  5.  Copy signature from Word to clipboard.<br>
  6.  Open Access.  Open linked Users table.<br>
  7.  Paste into OLE signature field.<br>
  8.  Update record.<br>
  I suspect the magic is in the copy of the image from Word to the clipboard, that it somehow creates an OLE object of some kind that is copied to the clipboard, then is able to be pasted into the varbinary(max) field via Access.<br>
  Can anyone shed any light on how one can programmatically (C#, Access, or?) load an image into a varbinary(max) field that Access can display as an image?  I want to create an application that the end user can use to upload the signature image.</p>