Access and Linked graphics 1

[foxrainer]

One of the tables in my database has linked graphics, the picture object on the form being appr. 2x2 inches.

In total, I have appr. 14 graphics LINKED so far, total size of all the pictures (jpg's) about 2mb

However, once all the pictures had been linked (again, only 2mb worth), the total size of the database jumped from 19mb to 64MB! An improvement of 3 MB (down to 61MB) was noted after optimizing the database.

I've made a copy of the database initially and used that copy to 'Embed' rather than 'link' the pictures and came out with appr. the same size.

Any clue why Access is taking up so much space with pictures, no matter is linked or not?

Rainer

 

[wildidee]

all pictures stored or linked in access database are internally stored as BMP files to ensure access speed

this inflates the DB dramatically

it is more interesting to store the picture path as text and call the picture via VB code in an independent image control rectangle