Frequently Asked Questions

To download the Exporter tool for Microsoft Access:

1. Log in to Oracle Application Express 3.0.
2. Under Migrations on the right side of the Workspace home page, click Application Migrations.
3. Under Tasks on the right side of the page, click Download Exporter for Microsoft Access.
4. In the Download column, click the zip file that corresponds to your version of Microsoft Access. For example, download the omwb2003.zip file if you are using Microsoft Access 2003.
5. Save the file.
6. Unzip the file. You must replace the following files with the updated versions in the msaccess_exporter directory where you unzipped Oracle Migration Workbench:
   1. schema.dtd file
   2. Exporter tool file: omwb.mde
   3. online help file: omwb.chm
   Be sure to invoke the export from this directory.

You have not associated the Oracle Application Express workspace with your migrated Oracle database schema. The Microsoft Access database must be migrated to Oracle, and associated with your workspace before using the Oracle Application Express Application Migration Workshop.

1. Run the Exporter for Microsoft Access tool, selecting the Export for Both option. Two files will be generated:
   1. XML file - containing database schema information
   2. SQL script - containing the application information
2. Download the Oracle Migration Workbench Release 10.1.0.4.0 or later, and its associated Microsoft Access plug-in from OTN.
3. Launch the Oracle Migration Workbench, and using its Capture and Migration wizards, migrate your Microsoft Access database to Oracle. The Migration Workbench uses the XML file generated by the Exporter tool, to migrate your database.
   Note: In the Migration Wizard ensure that the destination database for the migrated schema is the same Oracle instance as where you have installed Oracle Application Express 3.0.
4. Log in to Oracle Application Express 3.0 Administration Services, and create a new workspace.
5. Associate the new workspace with the migrated database schema, as created by the Oracle Migration Workbench.
6. Log in to the new workspace, and from the Home page, select the Application Migrations link under the Migrations task region to the right of the page.
7. On the Application Migrations home page, select the Create Project button to create a new Migration Project. Use the SQL script generated by the Exporter tool, to create the Migration Project.
8. On creation of a Migration Project, review the information contained in the Objects table.

You selected the Export for Oracle Application Express option in the Exporter for Microsoft Access tool. This option generates a SQL script containing the application forms and reports information extracted from a selected Microsoft Access MDB file. Oracle Application Express Application Migration Workshop uses this SQL script to create a Migration Project, and migrate forms and reports to Oracle Application Express. To generate the XML file and SQL script for a selected Microsoft Access database, select the Export for Both option in the Exporter for Microsoft Access tool.

You selected the Export for Oracle Migration Workbench option in the Exporter for Microsoft Access tool. This option generates an XML file containing the database schema information extracted from a selected Microsoft Access MDB file. Oracle Migration Workbench uses this XML file to capture and migrate the Microsoft Access database to Oracle. To generate the XML file and SQL script for a selected Microsoft Access database, select the Export for Both option in the Exporter for Microsoft Access tool.

The Form is based on a source object, of type Table or Query, which is valid but has not been included in the Migration Project. The source object must be included in the Migration Project before the form can be included.

1. From the Migration Project home page, select the Forms link.
2. For the Form with a status of Valid but with a grayed-out checkbox, note the Source Type and Source Name e.g. Source Type: Query and Source Name: Employees.
3. Using the breadcrumb, navigate to the Migration Project page. Select the Queries link.
4. Select the Employees query, and click Apply Changes to save the update.
5. From the Migration Project home page, select the Forms link.
6. The checkbox beside the form based in the Employees query is now selectable. Select the form, and click Apply Changes to save the update.

The Report is based on a source object, of type Table or Query, which is valid but has not been included in the Migration Project. The source object must be included in the Migration Project before the report can be included.

1. From the Migration Project home page, select the Reports link.
2. For the Report with a status of Valid but with a grayed-out checkbox, note the Source Type and Source Name e.g. Source Type: Table and Source Name: Employees.
3. Using the breadcrumb, navigate to the Migration Project page. Select the Tables link.
4. Select the Employees table, and click Apply Changes to save the update.
5. From the Migration Project home page, select the Reports link.
6. The checkbox beside the report based in the Employees query is now selectable. Select the report, and click Apply Changes to save the update.

The " Migrate To" option is only available for Forms based on valid source objects of type Table or Query, where the source object has been included in the Migration Project. A Microsoft Access form, based on a table or query, can be migrated to the following Oracle Application Express objects:

• Form (default option)
• Tabular Form
• Report and Form

Forms and Reports based on a source type of SQL Query have a status of invalid by default. Some SQL Query statements may require modification to make them valid Oracle syntax. For an example of a Form based on a SQL Query:

1. From the Migration Project home page, select the Forms link.
2. Click the Attempt to compile invalid SQL queries link at the bottom of the report region.
   Note: A SQL Query may only need to be compiled to make it valid.
3. Where the status of the SQL Query-based form is still invalid, click the SQL Query link in the Source Type column to edit the syntax.
4. On the SQL Query Editing page, click Edit and update the syntax in the editing area.
   Note: The Translation Scratch Editor in the Oracle SQL Developer Migration Workbench can be used to assist in the generation of valid Oracle syntax.
   1. Launch the Oracle SQL Developer Migration Workbench.
   2. From the menu bar, select Migration | Translation Scratch Editor, to launch the Translation Scratch Editor.
   3. Copy the SQL Query syntax from the SQL Query Editing page in Application Express.
   4. Paste the SQL Query syntax to the Enter SQL Statement window of the Translation Scratch Editor in the Migration Workbench.
   5. From the Menu Bar of the Enter SQL Statement window, select Access to PL/SQL from the select list. Then click the Translate icon to translate the SQL Query syntax.
   6. The translated Oracle syntax will be displayed in the Result window underneath the Enter SQL Statement window.
   7. Copy the syntax from the Result window in the Migration Workbench to the editing area of the SQL Query Editing page in Application Express Applications Migration Workshop.
5. Click Validate to check the validity of the updated syntax. The success message Valid will be displayed where the SQL Query has been validated and compiled.