Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Scanning to Database (Access 97 )

    I have one of those problems which has come from left field and need to see what your views on feasibility for this project.

    I work in a cash strapped working environment and the latest idea is that the Big Cheeses PA would like to scan his correspondence and have them easily accessible by using a database. I am very aware of bloating and my first tentative thoughts are to have the resulting scanned correspondence to be filed in an external folder with a table holding the references to the location of the files.

    Here are my first thoughts and would like you to advise me where I should start:

    1) Should I write a VB program connected to a database and do the scanning from that platform?
    2) Should I try and do the whole thing from within Access and if so how do I get the ActiveX controls to work?
    3) Advise them that the amount of development time will cost them more than going out to buy an 'off the shelf' product?
    4) Advise me on a cheap item for no 3
    5) Give up and have a beer
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scanning to Database (Access 97 )

    I would go with 3 and 5. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> Seriously, there are document management applications available for the kind of thing they want to do, but they carry a price tag. Once you find a few for comparison, start figuring how long it would take you to create an application to do something similar then calculate the implicit cost of having you do it based on an hourly rate. Now double that figure because it will take at least twice as long as you think. How do the two costs stack up?
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Scanning to Database (Access 97 )

    As to 4), you might look at a product called DocuData - it is Access based. We've used another product of theirs in the past with reasonable success, but I have no idea what the price might be. We have used a product called Alchemy, but it would be overkill for you as it is SQL Server based. Finally, I agree with Charlotte 100% - in addition to saving your time, you can push problems off on the vendor if you buy a system. If you design it, you have to respond to all the problems. My <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Wendell

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scanning to Database (Access 97 )

    Thank you Wendell

    Charlotte and your goodself have totally agreed with my thinking ( I was trying to justify my position <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> and go out for a no 5 instead.)

    Just as a matter to put my mind at rest, when I go to my Toolbox and get extra controls from it, I have a set of Kodak image controls. If I add one to a form they do not show in Form view! Is this because they are not part of the Access control set and are showing via my VB6 installation?
    Jerry

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

    Re: Scanning to Database (Access 97 )

    Although I don't have the Kodak image controls, I suspect that they are invisible controls, meant to be used in code. You will probably need documentation to use them.

    The Microsoft Common Dialog control is another example of an invisible control. It can be used to display six different dialogs: the File Open, File Save As, Color, Font, Print Setup and Print dialogs, but it is controlled entirely in code; the control itself is not visible in form view.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scanning to Database (Access 97 )

    The Kodak image controls were, I believe part of the Kodak imaging applet that came with Windows until WinXP. If you just want to display images, use the regular image control, not the Kodak controls.
    Charlotte

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scanning to Database (Access 97 )

    Yep

    That seems to make sense, I have just realised that there is the Kodak imaging software in my Win98 set up which I have never used!
    Jerry

Posting Permissions

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