Cloud storage alternatives for Microsoft Access database

Backend
1

Hey everyone,

I’m looking for some advice on moving our company’s database to the cloud. We’ve been using Access for a while now and want to keep the front-end as is. But we need to shift the tables to a cloud solution.

A few things to note:

  • We don’t want to use SharePoint or pay for Office 365
  • We’re open to other backends (I tried MySQL before but had to install extra drivers)
  • We’ll be importing data from Google Forms regularly

Any suggestions on how to integrate an Access front-end with Google Forms data and a cloud-based backend would be appreciated.

Thanks for any ideas!

2

Have you looked into Amazon RDS? It’s a managed database service that supports multiple engines, including MySQL and PostgreSQL. You could connect your Access front-end to it using ODBC drivers. For Google Forms integration, you might want to explore AWS Lambda functions to automate data imports. This setup could provide a scalable, cloud-based solution without tying you to Microsoft’s ecosystem. What’s your team’s experience with AWS services? It might require some initial setup, but could offer long-term flexibility and cost-effectiveness for your needs.

3

have u considered postgresql? it’s free, robust & can handle access front-end. for google forms integration, u could use zapier or similar tool to automate data import. might need some tweaking but should work. wat’s ur data volume like?

4

i wonder if azure sql database might be a good fit? its friendly with access and scales well. how many users and whats ur budget? cloud migrations can be tricky, dont ya think? curious to hear your thoughts.