I have inherited a legacy Access app. I want to modernize the app and turn it into a standalone, browser based desktop application that hits the local Access database in the background. No Web work at all for this one. I know my way around Access very well and I know enough Java, etc. to be dangerous.
I would love a gui driven tool that will enable me to design windows, read/write to the database, write code in the background, etc., kinda like we do in Access, except it produces html/javascript code for browsers.
Any suggestions? Has anyone done something like this before, and if so, what tools did you use? Thanks in advance!
Some starter questions…
Are you running Sharepoint or Office365 on an internal system, or are you trying to make this available to the public?
If to the public, will you support access on Android and Apple devices?
If you’re only concerned with an internal network, but not running Sharepoint, is the server environment LAMP or WIMP?
Have you considered moving the data to MySQL? You could still use Access as a frontend, but there are tools that allow browser-based access to MySQL tables. Some are even free, such as
VFront. (just an example - no idea if it’s any good)
There’s Zoho Creator, which announces itself as ‘like Microsoft Access on the web’ - it looks like it might be a bit spendy though, and may not have a self-hosting option.