Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Putting a lot of pictures in access

Discussion in 'Information Technology' started by danijela.simunovic@gmail.com, Nov 6, 2005.

  1. danijela.simunovic@gmail.com

    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Putting Sunshine In The Tank Breaking News Jul 9, 2011
    Pacific Anuradha Koirala: Putting a Stop to Trade in Women Breaking News May 24, 2011
    Giving Up Your Spiritual Journey (and Putting Down Roots) Spiritual Articles May 5, 2010
    Putting Your Faith in God Spiritual Articles Feb 13, 2006
    Putting the Fallouts of the Islamic Invasion and British Occupation of India in Perspective (News Fr Interfaith Dialogues Jun 2, 2005

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    danijela.simunovic@gmail.com wrote:
    > 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.

    --
    Joseph Meehan

    Dia duit
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    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

    <danijela.simunovic@gmail.com> wrote in message
    news:1131208928.743758.183470@g47g2000cwa.googlegroups.com...
    > 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
    >
     

Share This Page