DB2ASP - Free Access Database to ASP Converter

DB2ASP generates an Active Server Page framework from an Access database. The framework contains Script subroutines to display and validate html forms and update the selected table or query. This won't do everything for you but it will jumpstart your development process by automatically generating tedious code.

Overview

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.

UI Details

Run db2asp.exe.

In the Register Form, if you don't have a register code, Click Cancel.

Click Select.

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.

Click Start.

Some ASP file which containing the JavaScript code will be generated on the output path. Copy this file and database to your Inetput/wwwroot path and run it. You can also edit it with your editor.

Code Details

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.

db.asp :

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.
connstr="driver={SQL Server};server=localhost;uid=sa;pwd=;database=DatabaseName"

fileedit.asp :

This file is your data edit form. You can change your edit form interface here.

filelist.asp :

This file is your data listview interface.

filefilter.asp :

This file is your data data filter form.

Hints

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.

Requirements

At least 32 MB RAM

MS Access 7.0 or higher (ODBC is not required)

Necessary privileges to write into the destination database

Price

DB2ASP Converter is totally free with no limited features.

Downloads

Click here to download totally free version of DB2ASP converter.

Installation

After downloading the zip program you should simply unzip it and run the db2asp program.

Contact

William Long
e-mail: williamlone(at)gmail.com
website:http://www.moon-blog.com

Free Online Translation Tools

Google Translate - Google's free online language translation service instantly translate text and web pages. This translator supports: English, Arabic, Bulgarian, Chinese (Simplified), Chinese (Traditional), Croatian, Czech, Danish, Dutch, Finnish, French, German, Greek, Hindi, Italian, Korean, Japanese, Norwegian, Polish, Romanian, Russian, Spanish, Swedish, Portuguese.

Windows Live Translator - Microsoft Windows Live Translator is a free online language translation service for text and web pages. This translator supports more than 25 translation languages.

Babelfish - Yahoo Babel Fish provides free online text and web page language translation tools. You can use this site to translate words, phrases, or entire web sites into 19 pairs of languages, including to and from English, Chinese, French, German, Italian, Japanese, Korean, Portuguese, and Spanish.

Systran - Systran is a leader in providing language translation software products and solutions for the desktop, enterprise and Internet. With Systran products or solutions you can instantly translate and understand foreign language content into 52 language pairs.

Free Access to MySQL Database Converter

DB2MYSQL Converter is a totally free software that will convert Microsoft Access Databases to MySQL. It's easy fast and accurate MS Access to MySQL Database Converter easily converts database records of Microsoft MS Access databases to MySQL server.

DB2MYSQL is very easy to use, just follow the simple screens and let the program automatically do all the work for you. We use a very fast conversion algorithm to provide you with the best possible performance level.

Its Features include: Supports common MySQL data types and attributes. Supports common MS Access column data types and attributes. Works with all versions of MySQL servers running all platforms. Works with MS Access 97, 2000 and XP. Create a dump file. Select tables to transfer. Easy install, uninstall and upgrade.

Limitations

• Does not convert forms, queries, reports and Visual Basic scripts


• Does not convert system (hidden) tables

Requirements

• At least 32 MB RAM


• MS Access 7.0 or higher (ODBC is not required)


• Necessary privileges to write into the destination database

MySQL dump file

Access-to-MySQL converter allows users to do indirect conversion and get more control over the process. Following this way, the program converts MS Access data into a local MySQL dump file instead of moving it to MySQL server directly. This dump file contains MySQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into MySQL database.

Price

DB2MYSQL Converter is totally free with no limited features.

Download

Click here to download totally free version of Access-to-MySQL converter.

Installation

After downloading the zip program you should simply unzip it and run the db2mysql program.

Contact

• William Long


• e-mail: williamlone(at)gmail.com


• website:http://www.moon-blog.com