Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

You are correct. On my own primitive experience, I can say that Postgres has tons of stuff that can replace VBA on the back end. Alternatively Php maker 2020 does a lot of hard work for you, give it a try and you will see what I mean. It comes down to how complex your app is and what are you trying to do. I have been using Postgres and it is very good. But i am not an enterprise developer, i am the average joe that ditched excel for ms access.

On Tue, Jun 8, 2021 at 10:32 AM Lists <lists@pstrauss.net> wrote:

Converting the Back-End is relatively easy, even if you have to create the tables and relationships by hand. What is the real challenge is converting the forms, reports, and VBA to something that will run in a browser.Every time someone asks this question, the responders always seem to only talk about converting the Back-End. I don't think anyone knows of an answer to converting the Front-End; I certainly don't.

I would love to find that there is some tool, free or paid, that will convert the Front-End, even if only partially. It would be great to be able to build the program in MS Access, with the Back-End in some Client/Server Database on a web host, and then convert the Front-End to a bunch of web pages. Then the user could take his desktop app on the road. Who wouldn't love that? How much would a client pay for that? Not so easy without a tool.

A big part of the problem, as far as I know, is that MS Access is so much more powerful than a web page. Web pages are pretty powerful, and they seem to be getting better all the time, but browsers have a ways to go to catch up to Access forms. Emulating Access completely in JavaScript is probably not possible, but some JavaScript guru might think otherwise and I'd love to be wrong here. Perhaps Java would be the way to go, but I have no clue here as don't know anything about Java. I also have no idea how to get the kind of reports from a web site, as a PDF or as another web page, the we can dash off in Access in an hour or two.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116019) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_