I have an Access 2010 odbc front end with a SQL Server 2012 back end. My images (
.bmp) are stored as
Varbinary(Max). When I insert an image using my bound object frame in an Access form, the image displays on the form and report perfectly. I had a large number of pictures to bring into SQL so I used the following code in SQL Server Management Studio:
UPDATE dbo.Photos_Observations SET [Photo] = (SELECT BulkColumn FROM Openrowset( Bulk '\\serverIP\servername\020.BMP', Single_Blob) as MyImage) WHERE PhotoTableID =391
This worked well and all 600+ pictures are now in SQL Server. BUT the ones I added this way don't show up on my Access form or report. When I click on the Bound Object Frame I get Error number 502753 "A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control."
Why does it work one way and not the other? How can I get the images to display?