Skip Headers
Oracle® Application Express Application Migration Guide
Release 3.1.2

Part Number E12854-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

1 Overview of the Migration Process

This section provides an overview of the process of migrating applications from Microsoft Access to Oracle Application Express.

This section contains the following topics:

About Application Migration

Oracle Application Express Application Migration Workshop (Application Migration) enables you to migrate a Microsoft Access application and generate an Oracle Application Express application from the retrieved objects.

This migration begins with exporting your Microsoft Access metadata, using the Exporter tool together with Oracle SQL Developer Migration Workbench. After that initial step, you use Application Migration to review the retrieved objects and resolve any issues regarding invalid objects. As the final step, you have the option of generating either an application based on valid forms and reports or a maintenance application based on valid tables and views.

Once the application is generated, you can take advantage of all the functionality in Oracle Application Express to further develop and publish the migrated application.

Forum for Application Migration

In addition to Oracle support, you can post questions on the Microsoft Access Migration to Oracle Application Express:

http://forums.oracle.com/forums/forum.jspa?forumID=356

Preparation Checklist for Migrating Applications

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

Analyze Your MDB File in Microsoft Access

Using Microsoft Access, you should analyze your .mdb file before you export your database. Performing these steps will minimize errors in the migration.

  1. In Microsoft Access, analyze the objects in your .mdb file:

    1. From the Microsoft Access menu bar, select Tools, Analyze, and then Documenter.

    2. Select the All Object Types tab, and then click the Select All button to select all the objects within the application for analysis.

    3. Remove or resolve any erroneous objects reported by the Documenter.

  2. Ensure the application contains no missing references:

    1. In Microsoft Access, launch the design IDE (press Alt+F11 keys).

    2. From the menu bar, select Tools and then References.

    3. Remove or resolve any missing references.

  3. Ensure the application compiles successfully:

    1. From the menu bar in the IDE view, select Debug and then Compile.

    2. Resolve any reported errors.

  4. Perform a compact and repair on the database:

    • From the menu bar in Microsoft Access, select Tools, Database Utilities, and then Compact and Repair Database.

  5. Ensure that all linked tables are valid links:

    1. From the menu bar in Microsoft Access, select Tools, Database Utilities, and then Linked Table Manager.

    2. Verify that all links are up-to-date and pointing to an existing .mdb file that is not read-only.