ASP Access Database Interface Online Generator Wizard
(Is that enough 'buzzwords'?)
SCRIPTS, easy to customize! Now for generating data display and for
inserting new records. Download
Script Generator Wizard to use on your own site.
Example of generated scripts.
I spent HOURS putting this thing together for my own use. If you like it please rate and review it at www.aspin.com or if you find errors or have suggestions for improvement please email me. (I think it is nice, when you find someone's code to be helpful, to let them know; if we take and take without showing any appreciation, why should folks continue to give away code?)
I find that quite frequently, I don't want lots of bells and whistles. I'd rather just use bare-bones ASP coding to get the job done quickly and easily. I wanted something so simple that even an ASP newbie such as I was not so long ago, could use it.
There are several script examples and tutorials that I've used over and over and you'll see them noted on these pages.
I got to where I was dreading customizing a database display script yet again with a different set of table names and field names.
There are some free script utilities and generators that create database interfaces, but I wanted something that wouldn't require me to type in the field names and that would display selected fields and not just spew all fields out indiscriminately. (See also the classic Buildapp, which is awesome!)
Microsoft Access can be used to export database display as an ASP page, but then I have to rewrite the database connection and that's too much work... I wanted something that would automate database interfaces quickly and easily, plus be *FUN!*
Never one to back away from working harder to design something that will be *FUN!* to use, I decided to code a wizard that detects your Access filename, then displays the Tables and Fields for selection, and then writes the script to display the records in a table.
The wizard isn't perfect because sometimes the generated code has small, easily fixed errors. Still, it is a nice timesaver. These pages are the demo to show you how the wizard works. I have disabled the upload of the demo, but you may download the fully-functional creation scripts and install them on your own server.
Please email me if you find this useful or interesting at all. Please email about errors you find.
Please note also that the generated scripts are BARE BONES without any security code, etc. Use at your own risk. To use, just download the zip file, open it and then place all of the files inside a web folder together. Proceed to the Wizard Demo4
4Get this script set:
Just copy and paste each script into notepad then save it.
As you find errors, please email me so that I can fix the problems. Thanks!
1. MemoField =
request.form("GALLERY_DESCRIPTION") ' Field from form
2. Some of the scripts may be generated w/o the sql request.form fields formatted properly: request.form(text) -- change to request.form("text")