<p>I've got an MS-Access app (1/10th MS-Acccess, 9/10ths MS-SQL) that needs to display photographs of some assets along with their specifications. Currently the images are stored in an MS-Access table as an OLE Object (and copy-n-pasted into the field by the users).</p>

<p>For various reasons, I would like to do is store the original .jpgs in a folder on the network drive, and reference them from the application portion. I have considered moving into MS-SQL's image data type (and its replacement varbinary), but I think my user population will more easily grasp the concept of the network folder.</p>

<p>How can I get MS Access to display the contents of a .jpg?</p>

[{'answer_id': 40182, 'author': 'Daren Thomas', 'author_id': 2260, 'author_profile': 'https://Stackoverflow.com/users/2260', 'pm_score': 0, 'selected': False, 'text': '<p>The easiest way is probably to plop an Internet Explorer onto one of your forms. Check out this site: <a href="http://www.acky.net/tutorials/vb/wbrowser/" rel="nofollow noreferrer">http://www.acky.net/tutorials/vb/wbrowser/</a></p>\n\n<p>Since you can reference that object in Access, you will only need to point the webbrowser control to the path of the .jpg (NavigateTo() if I remember correctly).</p>\n\n<p><strong>EDIT:</strong> The above link was just googled and picked from the results (first one that opened quickly). I do not think it is a very good tutorial, it just has all the pointers you need... Check out msdn etc. if you need more information!</p>\n'}, {'answer_id': 41036, 'author': 'WaterBoy', 'author_id': 3270, 'author_profile': 'https://Stackoverflow.com/users/3270', 'pm_score': 4, 'selected': True, 'text': '<p>Another option is to put an image control on your form.  There is a property of that control (Picture) that is simply the path to the image.  Here is a short example in VBA of how you might use it.</p>\n\n<p>txtPhoto would be a text box bound to the database field with the path to the image\nimgPicture is the image control\nThe example is a click event for a button that would advance to the next record.</p>\n\n<pre><code>Private Sub cmdNextClick()\n    DoCmd.GoToRecord , , acNext\n    txtPhoto.SetFocus\n    imgPicture.Picture = txtPhoto.Text\n    Exit Sub\nEnd Sub\n</code></pre>\n'}, {'answer_id': 41321, 'author': 'Fionnuala', 'author_id': 2548, 'author_profile': 'https://Stackoverflow.com/users/2548', 'pm_score': 2, 'selected': False, 'text': '<p>I found that this article by Microsoft with full VBA worked very well for me.</p>\n\n<p><a href="http://support.microsoft.com/kb/285820/" rel="nofollow noreferrer">How to display images from a folder in a form, a report, or a data access page</a></p>\n'}, {'answer_id': 67132, 'author': 'David-W-Fenton', 'author_id': 9787, 'author_profile': 'https://Stackoverflow.com/users/9787', 'pm_score': 2, 'selected': False, 'text': '<p>Have you looked at Stephen Lebans\' solutions? Here\'s one:</p>\n\n<p><a href="http://www.lebans.com/imageclass.htm" rel="nofollow noreferrer">Image Class Module for Access</a></p>\n\n<p>Check out the list of other great code along the left-hand side of that web page. You may find something that fully matches what you need.</p>\n'}, {'answer_id': 1081292, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>You can try an ActiveX control called <a href="http://access.bukrek.net" rel="nofollow noreferrer">AccessImagine</a>, makes adding images to database more convenient - you can load from file, scan, paste from buffer or drag-n-drop. You can crop image right inside the database and resample it automatically. It handles external image storage automatically if you need it.</p>\n'}, {'answer_id': 25858063, 'author': 'Gord Thompson', 'author_id': 2144390, 'author_profile': 'https://Stackoverflow.com/users/2144390', 'pm_score': 0, 'selected': False, 'text': '<p>Note that in Access 2010 (and later) this is dead simple to do because the Image control can be bound to a field in the table that contains the <em>path</em> to the image file (.jpg, .png, ...). No VBA required.</p>\n\n<p>For more details see my other answer <a href="https://stackoverflow.com/a/25857967/2144390">here</a>.</p>\n'}]
['https://Stackoverflow.com/questions/40112', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/685/']