Embedded/Linked Pictures

[Paul G]

I have a table with a OLE Object field in it.

A data entry form has a bound object frame on it with the
OLE Object field bound to it.

Basically I am storing pictures of my CD covers in this
field.

However, every time I create a new record (and hence a
linked .jpg Picture in the OLE Object Field), the total
size of the database file is increased by about 10 or 12
MBytes !! The picture is not even embedded, only linked,
and the the original .jpg file (created in MS Photo
Editor) is between 30 and 100 kbytes. How can this be ?

Even compacting the database does not make any difference.

Pretty soon I am going to reach the 2GByte limit.

Can somebody help, please?

 

[Exponent]

Storing images this way leads to an uncompressed bitmap being stored in the field - this can be 10 to 100
*times* the size of the original file.
If you want to keep the image actually in the database you should store just the raw binary image data
(then it will require the same space in the db as the file would on disk). Otherwise you can work entirely
with external files.