can I link to a ms access 2016 file stored on Amazon S3

I have a split database. I want to allow multiple users to read and write data to tables in the back end through a cloud-based option. Can I do this with Amazon? If not, is there another site that would work for this project?
LVL 1
DexterFanDatabase DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
No, and No.

in order to use an Access database (an ACE database, in your case), the user must be on the same physical network as the database file, and that won't be the case with AWS. You also cannot use services like Dropbox for this.

There are instances of using this type of scenario in a WAN situation, but you must have a very robust, very reliable, and very high speed WAN setup.

The best way for multiple remote users to run an Access app is through Citrix/RDS. These are not inexpensive to setup and maintain, however.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<If not, is there another site that would work for this project?>>

 There is also storing the data in a back end sure as Azure or running on a server in the cloud, but unless the app is designed from the ground up for client/server (and 99% of Access apps are not), performance is usually dismal.

  RDS/Citrix as Scott mentioned is the way to go.   it's virtually plug and play for the most part.

 There is also www.eqldata.com, but I don't know if they are still in business or not.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<but I don't know if they are still in business or not.>>

 and it looks like not...can't reach the web site anymore.   Too bad...it was a great solution for a small number of remote users.

Jim.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
That was always my fear in ever using the eqldata site :-(
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.