Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pictures in a database

    This question has probably been asked before but here goes.
    I have a data base that has employee pictures in. I have tried converting the pictures to icons but the database is still slow. Besides some of the pictures don't convert depending on what type. I have jpg pictures, bitmap, etc. Jpg seems to be a smaller file size but the database still has slow response time. Any help would be appreciated.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures in a database

    Hi Linda,

    How slow is 'slow'? What kind of equipment are you using?
    How big are the pix (avg size)? Which version of Access?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures in a database

    Like mud! It takes about 2-3 minutes to bring up a record that has a picture in a form. I am at a company, so the equipment is OK. The .jpg file is about 417 kb, the .wmf about 7000, and the bitmap is slightly smaller than .wmf file. I have an image converter that I have been converting the .jpg files to bmp and wmf. I am using access 97.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures in a database

    Hi Linda,

    As an alternative to storing the pics in your database you could link to the files. You could then have a This <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=3603&page=&view= &sb=&vc=1>thread</A> talks a little about it...

    Also, attached is a file that has an example of this technique. I can't remember where I found it - maybe here on the Lounge. Just copy the 3 picture files to a folder called "C:Picture"

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pictures in a database

    The form works fine but how do I use this technique in a report?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •