Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

How the Oracle Migration Workbench for MS Access Reference Guide is Organized

How to Use This Reference Guide

Conventions Used in This Reference Guide

1 Overview

Introduction

Product Description

Features

Terminology

2 The Migration Process

MS Access Architecture

Jet Recordsets

Jet Multi-User Updates

Jet Enforced Referential Integrity

Jet Query Processor

Jet Transactions

Oracle Architecture

Triggers and Stored Procedures

PL/SQL Programming Language

Sequences

Transactions

Other Oracle Features

Jet/ODBC/Oracle Architecture

Preparing for Migration

Changes Made to the MS Access Database

Extending your Application

3 Data Types, Reserved Words, and Functions

Oracle Data Types

Jet Data Types for MS Access 97

Default Data Type Mappings

Oracle Reserved Words

MS Access Functions

4 Troubleshooting

Separation of Data and Application Files

Step by Step Manual Migration

Preparing Tables for Migration

5 Performance Tuning

ODBC Driver Selection

Server-based Parameter Table

Jet's Query Processor

Application Startup Performance

Runtime Performance

A MS Access Error Messages

Error Message Classes

MS Jet Error Messages

B Code and Query Samples

COUNTER Data Type Emulation

Name Mapping Query

Default Values

Column and Table Validation

CASCADE UPDATE Trigger Code

Index