Skip Headers

Table of Contents Image Oracle Migration Workbench Reference Guide for Microsoft Access 2.0, 95, 97, 2000 Migrations
Release 9.2.0 for Microsoft Windows 98/2000 and Microsoft Windows NT

Part Number A97262-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback

Go to next page

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


Go to next page
Oracle
Copyright © 1998, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback