(Week 6) Adding Pictures in Ms Access

Access provides several ways to store and display images. You can display images, such as pictures, logos, and photographs, on your forms and reports. To do so, you first need to store those images.

I've learned in Week 6 how to add pictures in Ms Access. Adding pictures in Ms Access especially in reports and forms would make it more presentable.

You can store Ms Access by embedding images directly in an OLE Object field in a database table. Object Linking and Embedding (OLE) is the technology used to share files among the various Office programs.  You use an OLE Object field when you need to store images (or links to them), and files from other Office programs directly in your database.


This method is the easiest to implement because you use the screens and tools that Access provides. Also, the images become part of your database and they travel with it. You never need to update the links to your image files.However, embedding images can rapidly inflate the size of your database and cause it to run slowly. This is especially true if you store GIF and JPEG files, because OLE creates additional bitmap files that contain display information for each of your image files, and those additional files can be larger than your original images. In addition, this method only supports the Windows Bitmap (.bmp) and Device Independent Bitmap (.dib) graphic file formats. If you want to display other common types of image files, such as GIF and JPEG images, you have to install additional software.

Source:

            http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx