Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

2 Migration Process

• 2.1 Overview of the Microsoft Access Architecture
  • 2.1.1 Microsoft Jet Database Engine Recordsets
  • 2.1.2 Microsoft Jet Database Engine Multi-User Updates
  • 2.1.3 Microsoft Jet Database Engine Enforced Referential Integrity
  • 2.1.4 Microsoft Jet Database Engine Query Processor
  • 2.1.5 Microsoft Jet Database Engine Transactions
• 2.2 Overview of the Oracle Architecture
  • 2.2.1 Triggers and Stored Procedures
  • 2.2.2 PL/SQL Programming Language
  • 2.2.3 Sequences
  • 2.2.4 Transactions
  • 2.2.5 Database Users
  • 2.2.6 Other Oracle Features
• 2.3 Comparing Microsoft Jet Database Engine, ODBC, and Oracle Architecture
• 2.4 Preparing the Microsoft Access Database for Capture
  • 2.4.1 Table and Field Name Considerations
• 2.5 Turning Off Security Settings in Microsoft Access
• 2.6 Extending the Application
• 2.7 Using Oracle as the Back-End
  • 2.7.1 Autonumber Options
  • 2.7.2 Default Options
  • 2.7.3 Multiple Forms Accessing the Same Record

3 Data Types, Reserved Words, and Other Database Objects

• 3.1 Oracle Data Types
• 3.2 Jet Data Types for Microsoft Access
• 3.3 Default Data Type Mappings
• 3.4 Oracle Reserved Words
• 3.5 Microsoft Access Queries
  • 3.5.1 Microsoft Access Queries that Use Parameters
• 3.6 Microsoft Access TRANSFORM Statements That Create Pivot Tables

4 Troubleshooting

• 4.1 Removing Microsoft Access Security
• 4.2 Migrating Relations with Queries
• 4.3 Defining Primary Keys on a Table
• 4.4 Migrating Table Data Using Microsoft Access ODBC Data Source
• 4.5 Incorrect Boolean Values When Migrating Data
• 4.6 Errors When Modifying a Microsoft Access Database

5 Application Performance Tuning

• 5.1 Selecting ODBC Drivers
• 5.2 Using Server-based Parameter Table
• 5.3 Improving Application Startup Performance
• 5.4 Speeding Up Microsoft Jet Database Engine Operations
• 5.5 Eliminating the Microsoft Jet Database Engine
  • 5.5.1 Qualified and Restricted Queries
  • 5.5.2 Snapshots Versus Dynasets
  • 5.5.3 Comparing Use of Drop-Down Lists

A Microsoft Access Error Messages

• A.1 Error Message Classes
• A.2 Microsoft Jet Database Engine Error Messages

B Code and Query Samples

• B.1 AUTONUMBER Data Type Emulation
• B.2 Name Mapping Query
• B.3 Default Values
• B.4 Column and Table Validation
• B.5 CASCADE UPDATE Trigger Code

Index