Link to home
Start Free TrialLog in
Avatar of Alexandre Takacs
Alexandre TakacsFlag 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.

Avatar of aikimark
aikimark
Flag of United States of America image

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.
ASKER CERTIFIED SOLUTION
Avatar of Mark Edwards
Mark Edwards
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of Alexandre Takacs

ASKER

Thanks for the suggestions / pointers
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.
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 ....