Results 1 to 4 of 4
  1. #1
    wackywoo105 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    34

    Microsoft Windows Image Acquisition Library very large scan file size

    I am using the Microsoft Windows Image Acquisition Library to scan directly from a button in an access form.

    I am using this to scan A4 files at resolution 200dpi in greyscale to jpeg. The scans captured by my access code are 3785KB in size. If I run the same scan using devices and printer the file size is 685KB.

    I have the following set up:

    Code:
     With wiaScanner.Items(1)
         .Properties("6146").Value = 2 '4 is Black-white,gray is 2, color 1 (Color Intent)
         .Properties("6147").Value = 200 'dots per inch/horizontal
         .Properties("6148").Value = 200 'dots per inch/vertical
         .Properties("6149").Value = 0 'x point where to start scan
         .Properties("6150").Value = 0 'y-point where to start scan
         .Properties("6151").Value = 1660 'horizontal exent DPI x inches wide
         .Properties("6152").Value = 2334 'vertical extent DPI x inches tall
         Set wiaImg = .Transfer(wiaFormatJPEG) 'Change file type in save to match format
     End With
    Does anyone know why the access scans are so large? Comparing the 2 images captured by different methods shows no real difference in quality.
    Last edited by wackywoo105; 10-03-2014 at 09:32 AM.

  2. #2
    wackywoo105 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    34
    After some extensive research found a way with ImageProcess to reduce the file size.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,643
    What is ImageProcess? Want to share details of your solution?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    wackywoo105 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    34
    Sure

    Code:
    Dim IP As ImageProcess
    Set IP = CreateObject("WIA.ImageProcess")
    IP.Filters.Add (IP.FilterInfos("Convert").FilterID)
    IP.Filters(1).Properties("FormatID").Value = wia.FormatID.wiaFormatJPEG
    IP.Filters(1).Properties("Quality").Value = 40
    Set wiaImg = IP.Apply(wiaImg)
    I looked at another method of just setting a property value but it didn't seem to work.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. MS-Access increasingly large file size
    By Herbie in forum Access
    Replies: 4
    Last Post: 01-14-2014, 12:08 PM
  2. Scan File to folder location from access
    By wrbuchanan2 in forum Access
    Replies: 3
    Last Post: 04-26-2013, 10:26 PM
  3. Replies: 5
    Last Post: 07-15-2011, 12:11 PM
  4. Replies: 0
    Last Post: 10-13-2010, 03:28 PM
  5. Replies: 0
    Last Post: 12-31-2007, 11:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums