access database course - Adding Pictures To A Form

Dear Paul

Thank you for attending our Access Intermediate and Advanced Course.

Let me tell you the main reason why you are encountering this problem and then I can give you three separate options to resolve the problem.

First of all I hope that you have set your Data type for the field to OLE.
After that you must have gone to the datasheet view and for individual record you must have chosen Insert> Object... and selected your image that you wanted.

Some technical information for you. Access usually supports only two file types namely .bpm (Bitmap picture or Device Independent Bitmap (.dib) files.

SOLUTION 1:
So the easiest solution would be to simply convert your jpg, gif or any other file to BMP files and that should resolve the problem straight away.

If you want to get more technical then please read further on.

SOLUTION 2:
If you have knowledge of VBA (Visual Basic for Application) then another solution can be to store your images outside the database and then use VBA to display them.


Office 2000 and 2002 comes with a program called Microsoft Photo Editor which provided the OLE server which in turn could display the gif and jpg pictures in your database but unfortunately in 2003 Photo editor has been replaced by Microsoft Picture Manager, which does not provide the needed OLE server for those types of files.

SOLUTION 3:
So another solution might be to reinstall the Photo Editor from previous version of Office which should be able to solve the picture problem.

I hope this helps!

If you need further assistance please do not hesitate to post it in the Forum Post

Many thanks

Kindest Regards

Rajeev Rawat

MOS Master Instructor 2000 and 2003