Migrating an Access Database to MySQL or dBASE

Microsoft Access databases are compatible with Sun ONE Active Server Pages running on Windows, but these databases do not run on UNIX or Linux systems. There are several options for connecting to a Microsoft Access database with Sun ONE ASP for UNIX or Linux, as described below.

Use SequeLink. The necessary steps for creating the connection string are described in Creating Connection Strings. The steps the system administrator must take are described in Configuring SequeLink.

Use the Sun ONE ASP Database Publisher tool to migrate an Access database to MySQL. For more information, see Database Publisher.

If you use FrontPage, you can easily migrate your Microsoft Access database to dBASE by using the Microsoft Access Export Table feature. You can then import the resulting folder of files to your FrontPage Web and use the Database Results Wizard. The dBASE database management system is relatively easy to learn and use. If you have moved a dBASE-based Web application to UNIX and then find that Sun ONE ASP cannot open the database, make sure that the file extensions of your dBASE files are in all capital letters (that is, *.DBF).