Access 2007 Bitmap Image vs Picture

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

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?


"M Skabialka" wrote in message
...
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

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" wrote in message
...
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?


"M Skabialka" wrote in message
...
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

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

"Sylvain Lafontaine" wrote in message
...
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" wrote in message
...
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?


"M Skabialka" wrote in message
...
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

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.

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.

"Fred" wrote in message
...
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.