document scanning with access?

[nkad]

How can I setup document scanning with an access db. I want the option to scan a document or multiple documents as apart of the data entry process using Access forums and controls.

[Ecniv]

Word docs?? (I assume)

I guess that there are three options:
1) See if there is already software out there which does what you want and allows you to use with access
2) Office automation - open word and scan through the doc via code. This would be either to specific points or using Word VBA
3) Forget it...

If you have the time available or it is very neccessary, mess around with recording macros in word and using that code as a base.

Note to code from Access to Word you may need to use a reference to the VBA or experiment with objects (the better but harder way).

Vince

[nkad]

Uh.... How do you get "Word Doc" out of Document Scanning... Do you know what Document scanning is?

You take a physical paper document, and scan it, and it gets stored in a database for quick retrival/reference.

This has nothing to do with word documents what so ever!

Thanks

[Ecniv]

Ok,

So you have probably a couple of choices:
1) Scan docs, store as pics on a hd, and store the pointer to them in access
2) upgrade to sql server and follow the tutorial Beacon made (top threads)
3) Use software already written to do this... there are several around
4) Obtain info on API calls to scan and then convert the file into Access, but I wouldn't recommend this as each scan is going to be big and the final mdb would be huge and slow...

Document scanning -
scanning paper to electronic
scanning through word doc for certain data / references
I took it to be the second type

Vince

[nkad]

Alright, your fired... Wise guy.

What I am really looking for is some kina of free or relatively cheap ActiveX control to access the TWIAN Scan Manager so that the images can be easily scanned and imported into the database with a click of a button.

But since you aparently dont really know any such active controls, that answers my question. I will just have to keep searching I guess.

scanning through word doc for certain data / references
I took it to be the second type

Wouldn't that be called Parsing?

[Ecniv]

http://15seconds.com/component/free.htm

Most sites I had a quick search (I am meant to be working) asked for 1 grand usd or more, mighty expensive!!

The link above has one webtwain, but maybe it will do what you need - or point you other sites...

Good luck in your hunt


Vince

[DaveBo]

Several years ago I wrote a VB app that used the Kodak imgscan.ocx, imgadmin.ocx and imgedit.ocx files.

If these are available to you try them out.

I don't remember much about how it worked, but here's a chunk of code from the "Scan It" button event:

    ' Setup properties for the ImgScan1 obj. for ref. only:
    ImgScan1.FileType = TIFF
    ImgScan1.Image = New_ScanFileName       ' writes out pages to TempScan.tif
    ImgScan1.MultiPage = True
    ImgScan1.PageOption = CreateNewFile
    ImgScan1.ScanTo = FileOnly
    ImgScan1.ShowSetupBeforeScan = False    ' prevent that screen from appearing
    ImgScan1.PageType = BlackAndWhite       ' (won't allow this? #3 instead)
    ImgScan1.CompressionType = CCITTGroup4_2d_Fax   ' ~35K/page

    ' Scanner is automatically opened

    If ImgScan1.ScannerAvailable Then
        ' 1st check if New_Scan.tif exists, if so, delete it
         If File_Exists(New_ScanFileName) Then Kill New_ScanFileName
        ImgScan1.StartScan

        ImgScan1.CloseScanner
        ' scan is now if file New_ScanFileName

Hope this helps, DaveBo