automation with scanner

[gstylianou]

My Friends Hello,
Since a long time ago i have a difficult issue that i'm trying to find a solution desperately. I said desperately because we have a thousands handwritten files (A4) which must be computerized and somehow to find a way to import them into a database that I have made for this purpose.

What we wanted to do:
We have a scanner (HP) which we scan a manuscript. I want to find a way so that can be able using a common command button (through my form) to start the scanner's software and finally when the procedure finished to be able to incorporated the scanned document into my database, without having previously be stored in a folder with an appropriate description ...

In fact, i want to do the following steps:

1. Using a common command button (through my form) to start the scanner's software and the related procedure.

2. When the scan completed, i want this document to comes directly into my database, but before that, i want to select the related customer which i want to add this file..

I would be grateful if anyone of our friends here has previously dealt with something similar in order help us, because it is really important issue for us to do this automation ..

Thanks in advance

 

[JHB]

Try to Google "scan direct into ms-access", it gives a lot of hints.
How do you want to store the scanned document in MS-Access?
If it is as a picture/pdf then your database will grow exceptionally much.

 

[gstylianou]

Hi JHB,

My opinion is just a direct link.... First to scan and then to save the document into a temporary folder....but access must keep the path an store it automatically....Any idea?

Thanks

 

[hafco]

I suggest you use the WIA object to automate the scanning process with VBA
I recently needed to build a scan application in MS acces.
Found some good information about how to do this ://stackoverflow.com/questions/17008480/scan-multiple-pages-with-adf-scanner-using-vba