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
已提問 2 年前檢視次數 266 次
2 個答案
1

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

已回答 2 年前
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
專家
Rob_H
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南