Digital Photographs in OLE Fields

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
T

Tony_VBACoder

No, you do not want to store the images within the
database, this has a very negative impact on the database
(Access gets bloated if you store a few images in a
table). Rather, you would store the path to the image in
a table, and then as you load each record in a form, you
would lookup the path to the image and display the image
in an "Image Control" on your form.

Check out the following article:

http://www.mvps.org/access/forms/frm0044.htm

-----Original Message-----
I am trying to enter digital photos into OLE fileds, and
I find that it takes an exceptionally long time to have
the entry accepted into the field. Is there a preferred
viewer that should be used to speed up the process? If
so, what is it and how does one activate it?
I had a horrendous time yesterday, because my PC used
DELL's Image Viewer and it totally locked up ACCESS. Has
anyone else experienced this problem?
 
Thanks for the information. your help is appreciated.
--
Tomk


Tony_VBACoder said:
No, you do not want to store the images within the
database, this has a very negative impact on the database
(Access gets bloated if you store a few images in a
table). Rather, you would store the path to the image in
a table, and then as you load each record in a form, you
would lookup the path to the image and display the image
in an "Image Control" on your form.

Check out the following article:

http://www.mvps.org/access/forms/frm0044.htm

-----Original Message-----
I am trying to enter digital photos into OLE fileds, and
I find that it takes an exceptionally long time to have
the entry accepted into the field. Is there a preferred
viewer that should be used to speed up the process? If
so, what is it and how does one activate it?
I had a horrendous time yesterday, because my PC used
DELL's Image Viewer and it totally locked up ACCESS. Has
anyone else experienced this problem?
 
Back
Top