Convert Access Tables Into ASP Web Pages
Convert Access Tables Into ASP Web Pages
By Danny Lesandrini
I hope the following article and associated code download will prove to be as useful and exciting for readers of DBJ as they have been for me. Creating web pages to interface with Microsoft Access databases is a natural evolution for Access developers and there is a plethora of great tutorial information out there.
Nevertheless, I continue to get requests from my Access developer friends and associates for a simple way to convert their databases. I finally decided it was time to clean up that old "table-to-ASP converter" and make it user-friendly enough to distribute. The result is a single Microsoft Access form that, when imported into any database will do the following:
1. Expose a list of tables from which you can select one to convert to ASP
2. Creates an ASP page based on that table's columns that will ...
* Display a text box for every field with data size validation
* Demonstrate how to load a record (links to top 3 ID values)
* Jump to the last (most recent) record
* Writes the code for INSERTS and UPDATES
3. Opens the ASP page in Notepad to allow you to view and edit the code
4. Supplies a hyperlink to the newly created web page
Read the rest here
Trackbacks
No Trackbacks
Comments
No Comments
