Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

How this Reference Guide is Organized

How to Use this Reference Guide

Documentation Accessibility

Accessibility of Code Examples in Documentation

Related Documentation

Conventions

1 Overview

Introduction

Product Description

Features

Glossary

2 Migration Process

Overview of the Microsoft Access Architecture

Microsoft Jet Database Engine Recordsets

Microsoft Jet Database Engine Multi-User Updates

Microsoft Jet Database Engine Enforced Referential Integrity

Microsoft Jet Database Engine Query Processor

Microsoft Jet Database Engine Transactions

Overview of the Oracle Architecture

Triggers and Stored Procedures

PL/SQL Programming Language

Sequences

Transactions

Other Oracle Features

Comparing Microsoft Jet database engine, ODBC, and Oracle Architecture

Preparing the Microsoft Access Database for Capture

Turning Off Security Settings in Microsoft Access

Modifying the Microsoft Access Database

ODBC Connection Issues with Linked Tables

Extending the Application

Using Oracle as the Back-end

Autonumber Options

Default Options

Multiple Forms Accessing the Same Record

3 Data Types, Reserved Words, and Functions

Oracle Data Types

Jet Data Types for Microsoft Access

Default Data Type Mappings

Oracle Reserved Words

Microsoft Access Functions

4 Troubleshooting

Removing Microsoft Access Security

Erroneous Relations within Microsoft Access 95

Migrating Relations with Queries

Defining Primary Keys on a Table

Migrating Table Data Using Microsoft Access ODBC Data Source

Incorrect Boolean Values When Migrating Data

5 Application Performance Tuning

Selecting ODBC Drivers

Using Server-based Parameter Table

Improving Application Startup Performance

Speeding Up Microsoft Jet database engine Operations

Eliminating the Microsoft Jet Database Engine

Qualified and Restricted Queries

Snapshots versus Dynasets

Comparing Use of Drop-Down Lists

A Microsoft Access Error Messages

Error Message Classes

Microsoft Jet Database Engine Error Messages

B Code and Query Samples

AUTONUMBER Data Type Emulation

Name Mapping Query

Default Values

Column and Table Validation

CASCADE UPDATE Trigger Code

Index