I have an application, a rather extensive one, that currently is a single user, desktop system. It really needs to be multi-user and run in the cloud. But, I don’t know how to make this happen and I’m hoping that there is an expert(s) who would give me advice and maybe even guide me through this process.
The application is written in Visual Basic and uses MS Access for a database. So, it’s a Microsoft application and I was thinking of using Azure. And I’ve learned that Access is not compatible with Azure so the database would have to change.
I don’t want to change the programming language. The app is just way too extensive for that. It was built over a period of years and changing the programming language would just be too daunting of a task. So, I’m very hopeful Visual Basic can be retained.
Retaining the codebase means I would retain the Windows application, desktop interface. Instead of the program connecting to a database that resides on the PC I would like to connect it to a database that resides in the cloud. That seems reasonable to me but it may not be possible, I just don’t know.
Is there anyone that has had experience with a conversion project like this that would offer me some tips/advice/guidance? Thanking you in advance.