1/13
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
Scripting on this page enhances content navigation, but does not change the content in any way.