how do i scan a image from a flat bed scanner using python and Microsoft access
-
hi please help me i have a project, need to write a code in ms access or python to do the able to press a button on the form windscreen that scans an image into my database field.
-
hi please help me i have a project, need to write a code in ms access or python to do the able to press a button on the form windscreen that scans an image into my database field.
You have already posted this: ACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER - Database Discussion Boards[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
hi please help me i have a project, need to write a code in ms access or python to do the able to press a button on the form windscreen that scans an image into my database field.
Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide. As things stand, I could probably tell you how to interact with my old scanner - but you can bet your bottom dollar it won't work for yours. So more detail would be needed. As an aside, storing the actual scanned image onto your "database field" is probably going to be a very bad idea. The Access file is going to get very big very quickly. You should consider storing the image on the file system (it's what it is designed for) and storing a link to it on the database itself (hint - using explicit paths or drive mappings is not a good idea - a rather bitter experience with FileNet proved this to me in the past)
-
Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide. As things stand, I could probably tell you how to interact with my old scanner - but you can bet your bottom dollar it won't work for yours. So more detail would be needed. As an aside, storing the actual scanned image onto your "database field" is probably going to be a very bad idea. The Access file is going to get very big very quickly. You should consider storing the image on the file system (it's what it is designed for) and storing a link to it on the database itself (hint - using explicit paths or drive mappings is not a good idea - a rather bitter experience with FileNet proved this to me in the past)
the database program consith of the following fields Name Surname Scanned document of The Person Please help i am new to programming i do not want to loose hope!
-
the database program consith of the following fields Name Surname Scanned document of The Person Please help i am new to programming i do not want to loose hope!
Quote:
Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.
If you are new to programming then getting a scanner to work through an API is probably beyond your current capabilities. Your table (it is not a database) should also include a unique identifier for the person (after all, people can have the same name). Do not store the actual document on the database, store it's relative path or it's path relative to a fixed folder name.