Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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

Topics
Storage
Tags
S3 Transfer AccelerationAWS BackupAmazon Simple Storage Service
Language
English

asked 5 years ago948 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.

AWS
EXPERT

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content