Viewing Embedded Pictures

[JEDI1]

I have inserted pictures in my Access database (2003) I can only see the
picture file name not the picture. I have defined the underlying table field
as OLE in case you ask

 

[Tom Wickerath]

Perhaps you do not have the Office Graphic Filters installed? Have a look at
this page:

http://www.lebans.com/loadjpeggif.htm

Embedding images using OLE (Object Linking and Embedding) is not very
efficient. The size of your database will increase a lot with each new image
you add. Things are better when using the new .accdb file format in Access
2007, but Access 2003 and all prior versions convert your images internally
to the bitmap format. Note that in Access 2007 you need to use the .accdb
file format, and you need to set an option to preserve the original file
format, in order to avoid the internal conversion to bitmap, with the
resulting file bloat.

My suggestion is to store your files in a folder external to your database.
Then store just the path to the image file, so that you can display it
on-the-fly. The version of Northwind that ships with Access 2003 demonstrates
this method, which you can find on the Employees form. Here is a sample
database that is a bit more advanced, but is based on this sample from
Northwind:

http://www.accessmvp.com/TWickerath/downloads/ImageDemo.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Patty Mitchell]

http://www.lebans.com/loadjpeggif.htm

http://www.accessmvp.com/TWickerath/downloads/ImageDemo.zip
http://www.accessmvp.com/TWickerath/
Who are you?

 

[Larry Linson]

http://www.lebans.com/loadjpeggif.htm

http://www.accessmvp.com/TWickerath/downloads/ImageDemo.zip
http://www.accessmvp.com/TWickerath/
Who are you?

Just what, specifically, do you want to know? The MVP program is explained,
and MVPs may, optionally, post a profile at
http://mvp.support.microsoft.com.

From my personal knowledge and communication with Tom, I know he is a very
astute user of Access, an accomplished database software developer, highly
respected by his peers, and well-qualified to create demos and answer
quetions here.

I hope that helps.

Larry Linson
Microsoft Office Access MVP