Best approach to convert Access 2003 ADP project to a cloud-based solution?

[Utopia65]

Remote connections are only as stable and responsive as your internet service. If you have poor internet service, you will have poor uptime stats.

Do you already have an Azure account?
Are you planning on using an Azure desktop in the "cloud" and replacing your in house servers? That will let you convert to a standard .accdb linked to Azure with the app running on the Azure desktop (best solution).

Do you plan on documenting the existing app or do you expect the next developer to figure out the business rules?

- No Azure here
- Yes
- Can give more details on the app. See my previuos post

 

[Utopia65]

Unfortunately, at least one of those assumptions is not entirely solid.

ADPs have never been a mainstream development platform in the first place, and since they were deprecated a decade ago, whatever limited knowledge existed has been slowly fading. Personally, I last looked at an ADP about 8 or 9 years ago. While it would be nice to be able to throw out a question and get piles of responses, it's not very realistic.

What you want from "the new cloud solution" is still not 100% clear in my mind.

Would Access accdb Front Ends on the computers of your two users work, assuming you also migrate your data from its current location to a hosted SQL Server database such as Azure SQL?

Or do you want a 100% "cloud" solution in which both the database and the interface are moved. In other words, do you want a browser-based interface as well?

In any event, the work is either going to be totally on your plate or on the plate of a hired consultant.

Once you have settled on the meaning of "cloud solution", there is room for further suggestions, though.

As per the DB, a cloud-based solution would help to remote the database, avoiding a local server, while for the front end, either a local ACCDB or web based solution (probably more costly) would be fine for us

 

[amorosik]

As per the DB, a cloud-based solution would help to remote the database, avoiding a local server, while for the front end, either a local ACCDB or web based solution (probably more costly) would be fine for us

Have you try Cybele Virtual UI ?

 

[BlueSpruce]

What you want from "the new cloud solution" is still not 100% clear in my mind.

Perhaps the objective is to support remote users? If so, the quickest and cost-effective solution is to migrate the app to Access365/SQL-Server on WinServer with Terminal Services, or other RDP solution. If a web portal is needed, the db server on WinServer with IIS can handle it.