db to store scanned documents

[tim johnson]

I plan to build an application that will store documents
of scanned records. Currently the records are on regular
paper 8.5 X 11 inches.

I know that the scanned copied will should be kept out of
the DB and a table should store the file location.

Building this is no problem but I want to get so feedback
from anyone who is famaliar with an existing system to
give me some general advise.


What type of scanning hardware is best suited since there
will be many documents daily?

Do you know of any existing system that I can look at the
interface and see how it is designed.

Thanks

I plan to build an application that will store documents
of scanned records. Currently the records are on regular
paper 8.5 X 11 inches.

I know that the scanned copied will should be kept out of
the DB and a table should store the file location.

Building this is no problem but I want to get so feedback
from anyone who is famaliar with an existing system to
give me some general advise.


What type of scanning hardware is best suited since there
will be many documents daily?

Do you know of any existing system that I can look at the
interface and see how it is designed.

Thanks

 

[Arvin Meyer]

Unless you have either lots of it (several thousands or more) to do, or have
a need for high security, I suggest that you use an outside source for the
scanning:

http://www.fedex.com/us/officeprint/storesvcs/technology/imaging.html?link=4

Should you need to do it internally, VisionShape was a company that supplied
a good scanner I saw used on one of my contract jobs.

http://www.visionshape.com/

As you mentioned, storing the data internally, is not particularly good
solution, as you'll fill a JET database quickly, so you'll need to use an
industrial strength database such as SQL-Server. If you simply want to store
the path's, my free DocMgr database:

http://www.datastrat.com/Download/DocMgr_2K.zip

will store millions of them. You may need to make some alterations to store
other filetypes (pdf's, etc.) but the code is open and the price is right
<g>
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access