Access Webserver (1 Viewer)

[Doozer]

Attached is an Access web server application that I adapted from webxcel project on github. The web server is written entirely in VBA. The attached folder consists of 6 files: 3 Access DB's, and the app files (HTML, CSS, and JSX).

To use the application, open the AccessWeb_BE file and link to the todo table in the AccessWeb_data file, then click the Start Server button. Once the button says "Running...", open the AccessWeb_FE file. The todo app will load at localhost:8080. You should be able to add new, complete, and delete items. When finished, click the stop button in the BE file to clear the port and delete the lockfile.

I just did this as an exercise. Use at your own discretion.

 

[arnelgp]

it is hanging on my pc (BE) when started the server.

 

[Gasman]

I got an error, which I am not going to try and reproduce as it then mucked up my diabetes DB that I have open all the time.
Had to restart my computer to try and clear the problem, even then Access said there was an issue last time I tried to open the diabetes db, and did I still want to open it.
Nice idea though.

 

[isladogs]

Same here. Access stops responding

 

[Doozer]

Sorry, I forgot to mention that it hangs around as a background process even after stopping the web server. I haven't debugged that issue yet. Thanks for testing and the feedback.

 

[Doozer]

I got an error, which I am not going to try and reproduce as it then mucked up my diabetes DB that I have open all the time.
Had to restart my computer to try and clear the problem, even then Access said there was an issue last time I tried to open the diabetes db, and did I still want to open it.
Nice idea though.

Sorry about that. Hope it didn't corrupt your database.

 

[Gasman]

Sorry about that. Hope it didn't corrupt your database.

No, it is back up and running.

 

[isladogs]

Sorry, I forgot to mention that it hangs around as a background process even after stopping the web server. I haven't debugged that issue yet. Thanks for testing and the feedback.

Unfortunately it never gets as far as starting the Web server. When I click the button, nothing appears to happen. When I click it again, Access just stops responding.
However I've since found that if I step through the StartServer code, it DOES work. So I think you need to add some delays to allow each step to complete before continuing.