Scan image from Access 2003 and save in file store

I want to press a button on a form which will scan a piece of paper on my scanner, save the scanned image using  the name of an auto number field in the database to a fixed prespecified location on my harddrive, store the location and name of the scanned file in a record in the database. I then want to later to be able to press another button to open the image so that it can be viewed. Preferably I'd like to use standard windws scanning app and standard windows image viewer. I don't want to do any OCR, just store and later retrieve the image direct from within Access. I'm using Access 2003 and Win XP.
Thanks

SJHAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
SJH,

If you read your post closely, you will see that you are asking several different questions here.
- I want to press a button on a form which will scan a piece of paper on my scanner
-save the scanned image using  the name of an auto number field in the database to a fixed prespecified location on my harddrive
-store the location and name of the scanned file in a record in the database
- then want to later to be able to press another button to open the image so that it can be viewed
-I'd like to use standard windws scanning app and standard windows image viewer.

...Perhaps you should consider breaking this Q up into smaller q's?
;)

BTW: Do you need help creating this *entire* system?
If so, it sounds to me like you might consider hiring a consultant to help you with this "Project".

In any event,... here is a search on this site of "Access Scan":

http://search.experts-exchange.com/advancedSearch.jsp?ssfTAIDs=39&ssfTerms0=Access+scan&sfNeglectedOnTop=false&ssfTermType0=1&ssfTermCount=1&advancedSearchSubmit=true&ssfConjoiner0=null&ssfTermInclude0=true&ssfTermScope0=5&sfWithinTA=39

JeffCoachman

0
SJHAuthor Commented:
Jeff
I realise I am asking a number of questions, however they are all related and therefore more simple to ask together. If I have just asked 'I want to press a button on a form which will scan a piece of paper on my scanner' and then ask one of the other questions separately, a perfectly valid answer to my first question could be completely useless when related to question 2. Here I'm giving an overview of the whole requirement. I would welcome a solution to any part of this.

This a tiny aspect of my system which has been well established over several years, I don't need a consultant just some pointers in the right direction.

I've been through all of the scanning related solutions but I can't find anything that drives the built in windows scanning app and then saves the file to disk automatically rather than into the db.

Any further comments welcome.
0
Jeffrey CoachmanMIS LiasonCommented:
SJH,

Fair enough.

<I would welcome a solution to any part of this.>
What would happen if someone answers one small part, and no one ever answers the others?
Would you consider the Q "answered", and award the points?
That is the issue with Multi-part questions.
... just bringing it up
:-)

<I can't find anything that drives the built in windows scanning app>
... There may not be...remember, the "Microsoft Office Document Scanning" program, works with/needs "Microsoft Office Document Imaging". The "imaging" portion may be how you hook into the scanning/programming aspect.
See here to download the programming interface:
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F93E445-B1CF-4477-A373-E17417D616BC&displaylang=en
& and here:
http://www.microsoft.com/downloads/details.aspx?familyid=7B6D9193-A1C8-4934-8007-47089FDE37DE&displaylang=en

See here as well, this involves OCR, but the person posting is a top expert here, and some of the links/advice might be useful.(My guess is that he got it working):
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23002740.html

Some "Programmability" sample code is here as well:
http://en.wikipedia.org/wiki/Microsoft_Office_Document_Imaging

Hope this helps
:-)

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SJHAuthor Commented:
Thanks Jeff
I'll take a look at the links. Looks like I've stubled across something that on the face of it sounds simple and a logical thing to do, but which is probably not as simple to implement.

Have a good weekend
0
Shanmuga SundaramDirector of Software EngineeringCommented:
Based on your request, it seems that you want to scan the image from the scanner and store it in the database. So you can try using the twain dll's to solve your need. when you google the net you can find many free drivers with source codes including vb6 code. This vb6 code with small modifications can be used in access VBA to solve your need. For eg. please see the link below

http://www.sweb.cz/lmik/
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.