• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2334
  • Last Modified:

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

0
SJH
Asked:
SJH
  • 2
  • 2
2 Solutions
 
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now