Using Microsoft Access to Scan Documents

With a click of a button you can use Microsoft Access to scan in documents to store on your server and retrieve easily again from within your database. 

You can now add a feature to your Microsoft Access database that scans a document and saves it for easy retrieval later.  By simply adding a button to one of your screens and adding some complex code behind the scenes, you can take anoher step towards a paperless office.  

How it works:

  1. You click the "Scan" button on one of your Access screens (forms). 
  2. A screen opens allowing you to choose where to save the document (usually on a central place on your server)
  3. Then your scanner screen will open (example below) allowing you to select your scanner options. 
  4. Then you click the button to start the scan
  5. The document is scanned and saved on your server as a PDF file.
  6. A link to that docuemnt is automaticlly stored in your Access database for easy retrieval of the document later. 
MS Access button to scan document 

Benefits

Your staff will no longer need to scan a document, manually save it to your server and then manually set a link to it in your database.  Your documents will be stored on your server and linked in your database automatically saving lots of time.