Re: Can we store images in Access?

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 04/27/04

  • Next message: Aaron Bertrand [MVP]: "Re: Error in updating memo field" 
    Date: Tue, 27 Apr 2004 14:48:59 -0400

    Although is is *possible* store images in OLE object in Access it is
    generally discouraged. It bloats the database very quickly and I suspect
    would make the database more prone to corruption much like Memo fields.

    The usual solution is to leave the pictures in a directory on your hard
    drive, store the path and filename in a record in the database, and just
    *display* the images in an Image control on a form or report.

    On my website (see sig below) is a small sample database called
    "Pictures.mdb" which illustrates this process. 

    -- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"S N" <uandme72@yahoo.com> wrote in message
news:eG2$WbILEHA.1272@tk2msftngp13.phx.gbl...
> Is it possible to store images inside an Access database?
> If so how?
>
>
  • Next message: Aaron Bertrand [MVP]: "Re: Error in updating memo field"

    Relevant Pages