I am working on my own project.
I need to scan a small document into
each record.How can I scan into attachment in one step  or
automate it? I assume this is best thing to do.
Thank you,  Lynn J Robbins

---

Reply from Richard Rost:

Lynn, I've been asked this question before. I don't really recommend scanning documents DIRECTLY into Access. However, most scanners have a feature where you can scan and save to file images (JPG or whatever). If you take all of your documents and scan them to a folder, then you can use the techniques I show in my Access Imaging Seminar to just go through and pick them, one at a time, and save the location (full path and filename) in your database. After that point, users can just click on your link to open the document. No need to save the actual documents in your database. That makes your database big and inefficient.