Hello all,
I have an Access application with a table with an OLEDB field, in which
photographs are linked. The photos are shown in a form. This worked well for
many years and now suddenly it doesn't show the photo automatically any
more. You have to double click on it.
After installing Office Photo Editor you can now see the photos, but now we
cannot link them; they have to be embedded, which means that we are coming
up to the 2 Gb limit.
Anybody know how to solve this?
Thanks in advance,
Jerome Smith
Mark - 23 Mar 2005 15:24 GMT
Instead of storing the photo in the database as you are doing now, store the
full path to the image file in a text field. I had inherited a database for
printing ID badges that was over 300Mb. After changing it to only store the
paths and not the images, the database went well under 5Mb.
This has been talked about in numerous posts, so a quick search for phrases
like "Linking Images", "Storing photos in database", etc. should give you
some good information.
> Hello all,
>
[quoted text clipped - 14 lines]
>
> Jerome Smith