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.