So many of the applications I create involve using web-based html forms to update Access databases that one day I just got tired of doing the same stuff over and over and came up with the idea for this program. The framework created by the program will display a blank form and data view, you can enter data into the form and write the form data back to the database. The wizard eliminates about 80% of the redundant coding associated with these types of applications. You'll still have to make modifications to the resulting code to fit your specific situations.
You need VB6 with service pack 5 and DAO 3.6 on your machine for the db2asp to run.
In the Register Form, if you don't have a register code, Click Cancel.
Select an existing Access database.
Select a table.
Select the fields you want to appear on the html form.
Select the filter method and search field.
Verify your selections.
The prgoram creates a Dim statement for each database field you selected. It also dims several other variables used throughout the framework.
Verify that sDBName points to a valid path on your server.
You can change your database connect string here. You can also change your database to another database system, such as SQL Server.
If you use SQLServer, change your connstr as below.
This file is your data edit form. You can change your edit form interface here.
This file is your data listview interface.
This file is your data data filter form.
Your Access database must have a field named "ID", and it should auto increase.
Your Access database must writeble. check the property of the database file.
At least 32 MB RAM
MS Access 7.0 or higher (ODBC is not required)
Necessary privileges to write into the destination database
DB2ASP Converter is totally free with no limited features.
Click here to download totally free version of DB2ASP converter.
After downloading the zip program you should simply unzip it and run the db2asp program.