Inserting Bitmap Images

[Charlie]

I have a simple flat database stored on a Network Server
originally set up in Access 2000 but now we use 2002.
When we add a record from one PC and insert a Bitmap
(Insert Object - Create from File.), it displays
correctly within the record in the form view. When we do
it from a second PC, the Bitmap shows up as a thumbnail
with the name of the file in the form view. What do I
need to do to have the image display correctly when
adding bitmaps from this PC? If I look at the Table, it
shows Bitmap Image for the records that the images were
inserted correctly from the good PC, but it lists it as
Package on the ones added from the other PC. Thanks in
advance.

 

[Larry Linson]

You are storing the picture as an OLE Object and that puts you "at the
mercy" of whatever automation-enabled software is registered to handle that
file type on the machine of the user where the database is executed. And,
the results from different imaging software can be different. There is a
property in the Bound OLE Frame to display a thumbnail or a logo, but that
may not be your problem... probably not if the identical database operates
differently on the two machines.

You'll find downloadable sample databases illustrating three approaches to
handling images in Access, along with an article and some sample JPG files
for testing. Two of the approaches do not store the pictures as OLE Objects
nor use Bound OLE Frames. One of those may serve your purposes.

Good luck with your project.

Larry Linson
Microsoft Access MVP

 

[Ben Pursley]

Where will we find this download? (I think I have a similar problem, and
would benefit to learn more about this topic)

--Ben