How to integrate Amazon S3 into Microsoft Access

0

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

TOPSie
asked 2 years ago463 views
1 Answer
0

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.

profile pictureAWS
EXPERT
Rob_H
answered a year ago