Inserting a .jpg file into an OLE object

[Guest]

I want to insert a .jpg photo in an OLE field record. I click on
Insert/Object and I want it create new.

The object type list reads:

Adobe Acrobat
Bitmap Image
Media Clip
Microsoft Equation
Microsoft Excel Chart
Microsoft Excel Worksheet
Microsoft Graph Cart
Microsoft Powerpoint Presentation
Microsoft Powerpoint Slide
Microsoft Word Document
Microsoft Word Picture
Midi Sequence
Package
Paintbrush Picture
Snapshot File
Video Clip

I have no options to insert a .jpg file and that is what I need. What can I
do?

Existing photos which came in with the imported database display properly. I
just can't add new ones.

Thank you for any help.

Mary

 

[Guest]

Mary:

I doubt that you do want to 'Create New' if you are inserting a JPEG
photograph. That means literally that, you create a new image by drawing it
in Paintbrush for example. You are more likely to want to 'Insert from
File', in which case you then simply browse to the .jpg file in question.

Its probably too late to change in your case as you have imported data, but
for future refernce this is not a very efficient way to include images in an
Access database; the file will become very large. A more efficient way is to
store the image files separately and store the path to each file in a text
field in a table. You can then load each image into a lightweight Image
control at runtime.

Ken Sheridan
Stafford, England