(SQL Server 2014, Access 2007)
I have spent a few hours trying to figure this one out. I hope I am missing something simple. To simplify my question let's say that we make a table in a SQL database with three columns: ID-(int), Item-(nvarchar(10) and Picture (varbinary(MAX).
The table in SQL is linked to Access and then we create a form for the linked table using the form wizard. The bound object frame in the form for the Picture will allow me to right-click and attach a jpeg without any issue. I can verify that the jpeg is making it into the table in SQL.
In the bound object frame properties I have the display type set to "Content" rather than "Icon". When I work with the form it only displays an icon with the actual file name below it. After the file name it displays "(Command Line)".
I need the image to actually show on the form. This function is going to be used for displaying inventory items to my coworkers on a split form so they can identify what we have in stock. I will be using the Cellica database app for capturing images with an Android tablet.
What am I doing wrong here?