How to integrate Amazon S3 into Microsoft Access

Question

I am supporting a well established Microsoft Access application. I have previously written a separate VB.Net application to backup the database to an AWS S3 Bucket. But I would like to integrate this backup routine into the MS Access code (VBA). If I try to add the dll's (AWSSDK.Core.dll & AWSSDK.S3.dll) from the VB.NET code as References to the Access(VBA) it fails "Can't add reference to the specified file". 
In Access terms References as Type Libraries. So where can I find a Type Library which gives S3 functionality to some VBA code?

Many thanks

Answer

Hi, I understand you're attempting to integrate Amazon S3 with Microsoft Access.
 
Unfortunately, AWS does not have any features available right now that can be directly used to integrate S3 with Microsoft Access. 
You will have to code on your side and use our SDK for Amazon S3.
 
Here is documentation that may help you understand this integration better:
https://stackoverflow.com/questions/4760957/can-you-integrate-amazon-s3-or-cloud-files-or-smiliar-with-ms-access-vba
 
Please contact AWS Support if you have any further questions, and feel free to reach out to us via a support case ticket to facilitate a discussion on the specifics of your resources!
https://console.aws.amazon.com/support/home#/case/create?issueType=technical

Answer

This would require additional infrastructure, But you can leverage an S3 Storage gateway: https://aws.amazon.com/storagegateway/ to create an SMB share that you can mount to your EC2 instance, this would allow you to backup to a drive that stores it's data to S3.

How to integrate Amazon S3 into Microsoft Access

Contenuto pertinente