how do I link photos without making database too large

[Guest]

When I link or embed a single photo (500 kb .jpg) to the database my backend
file goes from being 550 kb to 22.9 mb. Is there any way to add photos and
keep the file size down?

 

[Rick B]

Search google.com and click on "groups". Then type in...

microsft.public.access photos

Here is one of the responses that I think will help you the most...

--
Rick B

---------------------------------
Ron is correct. For more info and links see the Image Handling
section at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Al Camp]

Randy,
Use linking. Embedding grows the mdb size disporportionaly.
Get rid of all your pics just for now.
Compact the Database.
Check your mdb size.
Now try adding linked pic and check the size after that. It should be
much more reasonable.

 

[bob]

With jpeg images both OLE Embedding and OLE Linking typically cause a ‘preview’ image to be stored in the
field. The preview is stored uncompressed, so for jpeg can be anything from 10 to 200 times the size of
the original file.

Alternatives:

You can store just the filename in a text field and write code to display the image in an image control.
Note that the built-in image control often needs some workarounds, and relies on ‘graphics filters’ that
are not necessarily installed on target systems.

It is also quite possible to store the image itself in a field without this overhead, ie occupying only
the space that it does on disk. Displaying it then requires either extracting to a temporary file then
following the approach above (with the same caveats), or you can use third-party components that bind directly
to the field.

More info on these topics is available here:

http://www.ammara.com/articles/imagesaccess.html

http://www.ammara.com/articles/accesspictureole.html

 

[hclzy3344]

When I link or embed a single photo (500 kb .jpg) to the database my backend
file goes from being 550 kb to 22.9 mb. Is there any way to add photos and
keep the file size down?

 

[hclzy3344]

gdfgsdfgdsfgdsfgdsfgdsfgdfgdsfg