<div>
Well you could use the <a href="https://aws.amazon.com/sdk-for-net/" rel="ugc">AWS SDK</a> to create a .NET .dll that would be <a href="http://www.geeksengine.com/article/create-dll.html" rel="ugc">COM -Visible</a> thus using this to access the files stored in the S3 buckets.<br />
Personally i would go for the BLOB implementation...probably a Linux VPS hosting a Firebird Server which has good &quot;reputation&quot; for Blob handling
</div>


Well you could use the AWS SDK [https://aws.amazon.com/sdk-for-net/] to create a .NET .dll that would be COM -Visible [http://www.geeksengine.com/article/create-dll.html] thus using this to access the files stored in the S3 buckets.
Personally i would go for the BLOB implementation...probably a Linux VPS hosting a Firebird Server which has good "reputation" for Blob handling

Frontend Engineer and UX

Brandon Lyon

Consultant

gordonwwaugh

<div>
<div class="content wysiwyg-content">
Can I connect my MS Access front end to files stored in Amazon S3 buckets? <br />
<br />
I have an MS Access frontend is connected to an MS SQL Server backend. Among many other things, the Access frontend creates reports. VBA code within the reports currently display graphic files stored on a local network drive. The backend stores the pathnames of the graphic files. We want to move the graphic files either to a BLOB field or to Amazon as files in its S3 buckets. If we use S3, I assume we would store the file location (URL?) in a text field.<br />
<br />
However, I don't know whether Access will be able to access and display the graphic files stored in Amazon S3. Can this be done? If so, how? Is there an API that accomplishes this?
</div>
</div>


Can I connect my MS Access front end to files stored in Amazon S3 buckets? 

I have an MS Access frontend is connected to an MS SQL Server backend. Among many other things, the Access frontend creates reports. VBA code within the reports currently display graphic files stored on a local network drive. The backend stores the pathnames of the graphic files. We want to move the graphic files either to a BLOB field or to Amazon as files in its S3 buckets. If we use S3, I assume we would store the file location (URL?) in a text field.

However, I don't know whether Access will be able to access and display the graphic files stored in Amazon S3. Can this be done? If so, how? Is there an API that accomplishes this?

Connect MS Access frontend to graphic files stored in Amazon S3 buckets?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.