Scan Image And Store It in Database

[MAAS8000]

I made entry form and I have a column with an attachment type.
I want to run scanner directly from the form.
the available now is to scan the document to the PC then upload it as attachment to the database

 

[The_Doc_Man]

Suggest first that you search the forum for folks triggering a scanner, as I have never doine that particular step. The SEARCH function of the forum is in the thin blue ribbon near the top of the page just under the box that says: Welcome {username}, and is the third option from the right.

Search for "Trigger scan from form" as a possible topic.

Now, here is my take on the rest of this problem. Once you have scanned something, you can put the file in a particular folder, rename it to some unique name, and establish a hyperlink to the file.

Do NOT put the scanned image in the database. You have a limited amount of space (even though 2 GB is a large limit). Scanned images are among the most space-hungry objects you can store in a database. However, the hyperlink to the image is VERY small and if you keep the image as a separate file, only the space of the link counts against the 2 GB limit.

For comparison, a fully qualified link to a file will be measured in dozens of bytes but a scanned image will measure 1,000 times larger than that.

 

[MAAS8000]

I tried the search before but may i didn't use the correct words.
i will try the hyperlinks
thanks

 

[Gasman]

Start with this thread perhaps?

https://access-programmers.co.uk/forums/showthread.php?t=246348&highlight=scanner