Index

A  B  C  D  E  F  H  I  J  K  L  M  N  O  P  Q  R  S  T 

---

A

advanced server features, 2-4

application startup performance, 5-2

application system, 1-2

AUTONUMBER data type, 1-3

---

B

building a mapping query, B-3

---

C

Capture Wizard, 1-3

CASCADE UPDATE referential integrity constraints, B-4

CASCADE UPDATE trigger code, B-4

change default data types, 3-3

client/server, 2-4

column validation, B-4

Config, 5-2

COUNTER field, 4-2

COUNTER, NULL value, B-3

create sequence, 4-2

---

D

DAO, 2-2

DAOs, 2-2

Data Access Objects, 2-2

declarative default values, B-3

declarative referential integrity, 2-3

default data type mappings, 3-3

default values, 3-8

destination database, 1-4

drop-down lists, 5-3

dynaset, 2-2

dynasets and primary keys, 2-6

---

E

emulation of COUNTER data type, B-1

explicit transaction model, 2-3

export MS Access tables, 4-3

extending, application, 2-10

---

F

features, 1-2

field validation rules, 3-8

form loading time, 5-3

forms and reports, 2-8

---

H

hard lock, 2-3

---

I

implicit transaction model, 2-5

---

J

Jet, 2-1

Jet data types, 3-3

Jet error message classes, A-1

Jet error messages, A-2

Jet multi-user updates, 2-3

Jet query processor, 5-2

Jet recordsets, 2-2

Jet transactions, 2-3

---

K

key value index, 4-3

---

L

large-scale application, 5-1

local table, 2-8

---

M

manual conversion, 4-1

mapping query, 2-8

migration process, 2-1

Migration Wizard, 1-3

Migration Workbench, 1-2

modify MS Access database, 2-8

MS Access 97 data types, 3-3

MS Access architecture, 2-1

MS Access forms and reports, 2-8

MS Access functions, 3-8

MS Access operators, 3-11

MSysConf table, 5-2

multi-user MS Access application, 2-2

---

N

non-updateable snapshot, 2-6

nValue, 5-2

---

O

ODBC, 2-5

ODBC driver selection, 5-1

one-to-many cardinality, 2-3, B-5

one-to-one cardinality, 2-3, B-5

optimistic locking, 2-3

Oracle architecture, 2-4

Oracle data types, 3-1

Oracle Model, 1-4

Oracle reserved words, 3-5

---

P

parameter table, 5-1

performance of ODBC drivers, 5-1

performance of snapshots and dynasets, 5-3

pessimistic locking, 2-3

PL/SQL, 2-5

preparing for migration, 2-7

primary keys and dynasets, 2-6

---

Q

qualified queries, 5-3

---

R

reduce network traffic, 5-3

referential integrity, 2-3

remote table, 2-8

repository, 1-2, 1-3

reserved word conflicts, 2-9, 3-5

restricted queries, 5-3

result sets, large, 5-3

result sets, small, 5-3

runtime performance, 5-3

---

S

separate data and application files, 4-1

sequence, 2-5

sequence, definition, B-1

single-user MS Access application, 2-2

snapshot, 2-2

source database, 1-4

Source Model, 1-4

stored procedures, 2-4

supported Oracle data types, 3-1

---

T

table validation, B-4

table validation statements, 4-3

terminology, 1-3

transactions, 2-3

triggers, 2-4

tuning, 5-1