Access 2007 Bitmap Image vs Picture

[M Skabialka]

I created a database 2 or 3 years ago, probably in Access 2002 or 2003 where
one of the fields is defined as "OLE Object" and contains bitmap images.
I need to add more images but have forgotten how I did it. Currently the
new images are in an Excel spreadsheet (an updated version of the one I used
originally) and the images are small but can be resized using the handles.
The images currently in the database are all much larger and uniform in size
but I can't remember my method of creating the right size and getting them
into the table.
I am now using Acess 2007 without converting the database (the user is still
on ACC2003).
I tried to stretch the image in Excel and paste it into the picture control
on a form bound to the table, or directly into the table, but the table
shows this as a "Picture" while all of the others show as "Bitmap Image".
Is this just a different definition of Bitmap Image in Access 2007 as
Picture or is this a problem?
Is there a way to define a size of the picture and bring all 100+ pictures
in and save them as that size, without resizing using the handles, before
copy/paste?
Mich

 

[M Skabialka]

In trying to copy some of the pictures from Excel I noticed their source in
the formula(?) bar is =EMBED("MSPhotoEd.3","")
What does this mean? Also, the size handles are all circles - on the other
pictures the corners are circles, the middle handles are squares.

I just copy and pasted one of the EMBED pictures into the table via the form
and could not leave the field without hitting ESC to undo the paste. Trying
directly into the table it says Microsoft Photo Editor 3.0 Picture, and will
not let me leave the field without hitting ESC to undo the paste. After
clicking a few times elsewhere I finally got this message: "The OLE server
isn't registered. To register the OLE server, reinstall it." Is this
something to do with Acc07 as I have to return the database to the user in
Acc2003 format? I don't have the Photo Editor on my machine, so how can I
copy the pictures into Access?

 

[Sylvain Lafontaine]

Try copying them first to the clipboard and then onto your OLE Object.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[M Skabialka]

I pasted them into Paint, then back to Access, which worked. It is taking a
while, resizing as I go.

 

[Fred]

I noticed that nobody answered.

You may want to search previous posts on this. The gist of the large
amount of material is:

- Don't store pictures as OLE objects. Yours are some of the the many
problems which are the reason for this. Store them in a separate folder,
and store the path and file name in 1 or 2 fields. Use code to display them
on forms and reports.

As a side note, your post indicates some confusion with the "size" of
pictures. While they do have some "size" type attributes (number of pixels
etc.) what you are talking about as "size" is an attribute of the DISPLAY /
VIEW of the picture, NOT of the picture. An example is ordering different
sized prints of the same photo.....the size is how it's printed, not an
attribute of the image.

 

[M Skabialka]

If I copy a tiny image from Excel it is tiny in Access, and can't be
manipulated there. If I stretch it in Excel, and copy it, is is bigger in
Access. These images are less that an inch in Excel, many were shrunk for
the spreadsheet. I went into each and increased to 100% of original size
and pasted that into Access. These are parts for vehicles and need to be
big enough to be recognized. I was looking for a way to highlight many of
the pictures and tell them all to go to 100% but this does not seem possible
so far. I didn't create the spreadsheet so don't know why some pictures
were stored as OLE objects, but had to use Paint as a middle step.