Preparation Checklist for Migrating Microsoft Access Applications

Before you begin the migration process, verify that your system meets these requirements:

• Oracle Application Express version 3.0 or later

  You must install Oracle Application Express 3.0 or later. You use the Application Migration feature within Oracle Application Express to download the Exporter tool as well as to migrate Microsoft Access forms and reports to Oracle Application Express.

• Oracle SQL Developer 1.2 or later (available in English only)

  You must install Oracle SQL Developer version 1.2.0 or later. You use the Migration Workbench extension to migrate the Microsoft Access schema and data to Oracle.

• Exporter tool version 10.2.0.2.5 or later (available in English only)

  You can install the Exporter tool using the Download Exporter link within Oracle Application Express. For instructions, see "Step 1: Export Microsoft Access Metadata".

  If you are using Oracle SQL Developer version 1.2.0 or later, you can access the Exporter tool directly from the Migration menu.

• Microsoft Access

  Your local system must have Microsoft Access installed, and it must be installed where the Exporter tool and .mdb file reside.

• Microsoft Data Access Components (MDAC)

  Your local system should have the latest version of Microsoft Data Access Components (MDAC) installed. You can download the latest version from the Microsoft Web site.

• Printer

  Your local system must have a printer installed so that a report can be opened in design view. This is a requirement for exporting your Reports information from an .mdb file.

• Analyze your .mdb file before you export your database. Follow the instructions in the next section.