How to administer an Access database via web-based interface?

Question

There are times when I need to edit a database record to do something my CMS wasn't designed to do, so I have to manually edit it. Normally I just ftp the Access mdb file to my pc, make edits, and reupload the mdb file and hope nobody updated the database in the meantime. Does anyone know of a web-based database admin system that will allow me to edit Access data? Sure would be nice if I could install something on the server that would allow me to edit any datasource there and not have to have a separate, customized interface for each datasource.

Thanks for looking, Bill

Anonymous · Answer

a frightening way to do do it is to expose a page in your app that provides you a text area and a submit button. Then you can adHoc all night long using any SQL statement your hands can craft.To that end you can include a dropdown and use it to populate pre-built query templates into the text box.I would recommend naming that page with an extension that the web server will not serve. Rename it to use it and then rename it back when done.D.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded