How do I scan & store images in database

[Randy W. Sims]

What is the best way to provide a user form in access that allows
entering a few pieces of information and then providing a way from
within the form to let the user scan an image into the table? Also,
are there any gotchas or tips for storing large numbers of images in a
database? Is it possible to put the code in one db and have multiple
(possibly linked) dbs for the images, perhaps one db for each year?
There are probably about 5000 pages (8.5x11 in) that need to be stored
for each year, preferably in a resolution that can be printed out. We
are trying to store some old paper forms as images where it is too
expensive to actually convert the forms to data as they will rarely be
accessed and a few simple data fields will suffice for lookup.

Thanks,

Randy.

 

[Daniel Pineault]

To get some good advise on this subject you need to specify which version of
access you are working with.

If you are using 2003 or earlier, so should not any any circumstance save
the image to a table! Rather store a path to a folder where they are store.

If your are using 2007 the rules have changed and storing them within the db
is now acceptable.

Perform a search in this forum an you'll find numerous posts on this very
subject with lots of valuable advice.

 

[Randy W. Sims]

Sorry. I had intended to include that information. We're currently
using Access 2000. We could upgrade if that is the best option. Either
way I would like to find a way to do the scanning from within an
Access Form. I had done a little bit of searching on google on this
topic, and the only thing possibly useful there were some third part
controls like DBPix. I'll do some more searching in this forum.

Thanks,
Randy.

 

[Daniel Pineault]

Randy,

I had come across some code for this a while back. If you search this forum
you should be able to find this type of question and some help on the matter.

Also, I did a quick search and found the following sites

http://www.issociate.de/board/post/291567/How_to_control_scanner_from_Access?.html

http://www.thescripts.com/forum/thread442587.html
--
Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.