Developer

pts.
Tags:
DataManagement
SQL
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • IT1
    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.
    0 pointsBadges:
    report
  • Papp
    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.
    310 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following