Microsoft Access Database: Adding OLE Objects (Pics) to Tables and Form in Access

How to Add Pictures/Images to An Access Database

Here is a quick video tutorial (less than 3 minutes) to show you how to add pictures into an Access database application using the OLE object data type field technique.

This video tutorial is based on an earlier version (2003) but still works for the later versions (2007 & 2010).

Microsoft Access Database – My Comments

Be careful not to have too many OLE Object data type fields in an Access database table, as it will use a lot more memory than conventional data types namely Text and Number.

Like the Memo data type field, you can not set field sizes and is driven by the image file size therefore the quality of the image will matter making a black and white low resolution image more memory efficient than a full colour high resolution equivalent.

This entry was posted in Forms, MS Access, Tables and tagged , , , , . Bookmark the permalink.

3 Responses to Microsoft Access Database: Adding OLE Objects (Pics) to Tables and Form in Access

  1. Ben says:

    Hi,
    OLE Objects are not a perfect data type option for several reasons which I’m not going to run through here.
    But the easiest way to display an image using this data type is to ensure you use the more ‘bloated’ file size format BMP file type which is the default option.
    The Datasheet view for a form can be switched off which is part of the form’s properties (format tab) and you stop images being edited in the properties section too for the specific control (OLE in this case).
    If you want ot use other graphics formats, then you will need to download some other supporting application like Microsoft photo editor and change the configuration so thet OLE can recognise JPEG’s and GIFF’s but it’s now better practice to use hyperlinks to view images or the the newer data type for later versions of Access called ‘Attachments’.
    Ben

  2. Kholil says:

    Hi Ben,

    Thanks for the guide… it really helps. However, I have one situation for you to help me out :
    I have a table which I assigned to keep pictures (set as OLE Object). Then I developed a form connecting to that table to insert new pictures by double-clicking the OLE frame. I don’t want to use datasheet view and also I want to avoid users opening the table directly in design view. The problem is, I double-click and managed to embed new pictures, but I can just see the picture’s filename, not the picture itself (content). What should I do then?

  3. Ben Beitler says:

    Final point is to note this can be applied to a report too – just make sure you have a colour printer handy!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.