Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Database for scanned images (2002)

    For setting up a simple database to store all the receipts for warranty purpose, I am considering to use Access to store scanned image. The size is about 10KB to 60KB for each image. There will be less than 1000 images per year. The format of the image will be PNG and PDF.

    First question: Should I store the images inside the Access, as a field, or outside the access, as linked object?

    Second Question: How to call the scanner application from Access form?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database for scanned images (2002)

    You should definitely not store the images in your database. That is a sure recipe for database bloat. Whatever the image format, Access will also store an uncompressed bitmap image, which could easily be several megabytes per image.

    You can store the path and filename in a text field, and use an image control to display the image on a form (or report). Charlotte has posted a database in <post#=126927>post 126927</post#> that demonstrates how to do this.

    Alternatively, you can store the path and filename in a hyperlink field that the users can click to view the images in the application that is associated with them.

    I don't know the answer to your second question.

Posting Permissions

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