Link to home
Start Free TrialLog in
Avatar of Stephen Hoyle
Stephen HoyleFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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

Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

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

Avatar of Stephen Hoyle

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial