Avatar of Alexandre Takacs
Alexandre Takacs
Flag for Switzerland asked on

Cloudify MS Access app

We are tasked to “cloudify” an existing line of business application based on MS Access.

The app works well as is and seems to have been developed by a competent dev. The task at hand is really to make it hosted on some cloud server for users (about 5 simultaneous connections max) to use it.

I have reviewed services like https://www.apps4rent.com/microsoft-access-hosting.html which are, to the best of my understanding, RDS published apps.

Nothing wrong with that but

1. Is this a good way to achieve my goal ? Shouldn’t I actually manage my own (cloud) RDS machine ?
2. Is there any alternative for a “pure” Access in the cloud ?

Any advise / feedback most appreciated.

Microsoft AccessCloud ComputingRemote Access

Avatar of undefined
Last Comment
Alexandre Takacs

8/22/2022 - Mon

You could, potentially, split the database and move the back end to a server/cloud.

Doesn't mean that the entire Access application is in the cloud, since the front end would still be local.
Mark Edwards

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Gustav Brock

Shouldn’t I actually manage my own (cloud) RDS machine?
You could, but setting up a Windows Terminal Server is not trivial, so you may have to hire a skilled server administrator for the task.

Apps4Rent seems like a serious and fair offer to me, though I have no experience with their services.
Alexandre Takacs

Thanks for the suggestions / pointers
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Dale Fye

Another option is to simply put the data in Azure, and link to the Azure tables.
When you do this, you may need to re-write some queries to take advantage of server side processing, but I have several clients for whom this solution works just fine.
Alexandre Takacs

Another option is to simply put the data in Azure, and link to the Azure tables.
Is there a simple DB engine in Azure ?
Any migration tool ?
In my memorty SQL server is attrociously expensive in Azure ....