Putting a lot of pictures in access

[danijela.simunovic]

Hi again! I have a databse with 400 articles and the number is growing.
I would like to have a table with the pictures of those articles. I
tried putting a 80Kb picture in access and the database has grown by
1Mb. Then i tryed selecting "link" when i was putting the picture in a
table and the database grew by 1.5Mb. I tryed "Compact and repair..."
but the size was still huge! Is there a way to have the database in a
folder and in that folder another folder with all those pictures. And
link the pictures from the table and no mater where i put this folder
with the database and pictures they will be always linked (because the
pictures would always be in the folder where is the database). And of
course, i would like them to use as less space as possible!
Every solution would be great!

Danijela

 

[Arvin Meyer [MVP]]

The best way is to store them elsewhere on the drive or on a CD and link to
them from the database. An example of doing this is on my website:

http://www.datastrat.com/Download/Picture2K.zip

you can also store the images as a BLOB, but the size is still larger than a
textual path. For an easy (but not free) way of doing this, have a look at
DBPix:

http://www.ammara.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

Hi again! I have a databse with 400 articles and the number is
growing. I would like to have a table with the pictures of those
articles. I tried putting a 80Kb picture in access and the database
has grown by 1Mb. Then i tryed selecting "link" when i was putting
the picture in a table and the database grew by 1.5Mb. I tryed
"Compact and repair..." but the size was still huge! Is there a way
to have the database in a folder and in that folder another folder
with all those pictures. And link the pictures from the table and no
mater where i put this folder with the database and pictures they
will be always linked (because the pictures would always be in the
folder where is the database). And of course, i would like them to
use as less space as possible!
Every solution would be great!

Danijela

Yes, Access has file size bloat with images. As I understand it they
are all converted to BMP and that makes them larger.

I suggest you link to the images rather than import them.