scanning documents

[CompSMART]

Many years ago, when the office environment was transitioning from paper to digital, I used to allow users to scan directly from within Access - copy the file to a storage location and then store the path to the file Access. As time passed, I found that the overwhelming majority of items looking to be stored were already digitized (email attachments, local files, web documents, etc.) and I changed my design to allow users to drag and drop any file onto a form in Access and then move the file accordingly and store it's path in Access.

 

[The_Doc_Man]

Many years ago, when the office environment was transitioning from paper to digital, I used to allow users to scan directly from within Access - copy the file to a storage location and then store the path to the file Access. As time passed, I found that the overwhelming majority of items looking to be stored were already digitized (email attachments, local files, web documents, etc.) and I changed my design to allow users to drag and drop any file onto a form in Access and then move the file accordingly and store it's path in Access.

Sounds reasonable to me. And fairly efficient.