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.zipReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6775-putting-a-lot-of-pictures-access.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6775
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
Arvin Meyer, MCP, MVP
Free Access downloads http://www.datastrat.com http://www.mvps.org/access wrote in message
> 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!