Easy way to convert the MS Access database to Web application

Question

As per requirement, we need to convert the existing MS Access database to a web application. Is there any easy way to convert the MS Access database to web application? As of now they are inserting the data to access db using access Forms. User also wish to continue access form feature even if we create new web application for the same. That means user should have the option to access the MS access database through Access forms as well as web application.

Please guide me away to solve this issue.

Best Regards, Ranish

Solution

Four years after and according to this:

https://www.comparitech.com/net-admin/microsoft-access/

still a question for many. Access can be converted to an Web App in almost no time. Particularly Access Forms are super easy to crate with the library like Jam.py.

The process was discussed on Reddit in April 2021:

https://www.reddit.com/r/MSAccess/comments/mj4aya/moving_ms_access_to_web/

I see quite a few Access databases with more than 100 tables, all converted successfully to SQLite3. After inspecting the imported tables via provided link, Forms are automatically created. Which leaves the Access Reports and Business Logic untouched. Reports can be designed in LibreOffice for Jam.py as Templates. Business Logic can be moved from VB to Python, if there is a need to do so. The SQLite was selected as the default DB for the conversion, since it is very portable. Looks like the converted App can be moved to any DB that Jam.py supports, by Export/Import. Cheers

Comments

[Ranish]

Thanks. At present, Access Db having Access Forms, where user can add/modify details to database. Also user not wish to convert the access db to sql, since user want to continue the Access forms and these updates should access through web application. is there any easy way ? can I achieve it through share point?