Developer
Hi! I am currently developing a Document Tracking Database System using MS Access. I only have limited skills on access bt I'm willing to take an advice. Can you advise me on how to scan and save documents using MS Access database? Regards, Dee.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 12, 2007 10:24 AM
UPDATED:
December 3, 2007 3:22 AM
Answer Wiki:
Sort of a loaded question. When you say scan, are you going to import to a document format through OCR? If yes, then word or pdf would make for a better Access storage medium. If just to jpg, depending on the detail required, could get expensive hard drive realestate wise. To best answer your question, are the documents legal, pictorial, information, or all?
To see all answers submitted to the Answer Wiki: View Answer History.
Yes, I will import to a document format through OCR stored as a PDF file. All documents include pictures text and so forth and we need to store a soft copy of each for security reason.we have already developed the database but we then decided to store documents also.We actually need a simplest and less expensive way or maybe a command to use for storing scan data on database.
Access 2.0 was lean… and mean but broad distribution and security have made recent Access versions, not such an excellent medium for larger data formats. I am guessing if you have already gone production you are seeming massive increased use of drive space, even on NTFS-compressed. It all depends on how many shared access points you expect in use, and how much data, not just what you are inputting but how much can users change. This means you may want to store the scans in a separate server and use call-up links to the scans in the database. This will help tremedously to keep space and fragmentation down on the database itself.