Index

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

---

A

advanced server features, 2-4

application startup performance, 5-2

application system, 1-2

---

B

building a mapping query, B-3

---

C

Capture Wizard, 1-3

CASCADE UPDATE referential integrity constraints, B-5

CASCADE UPDATE trigger code, B-5

change default data types, 3-3

client/server, 2-4

column validation, B-4

Config, 5-2

---

D

Data Access Objects, 2-2

declarative default values, B-4

declarative referential integrity, 2-3

default data type mappings, 3-3

default values, 3-9

destination database, 1-3

drivers

ODBC, 5-1

drop-down lists, 5-7

dynaset, 2-2

dynasets and primary keys, 2-7

---

E

emulation of COUNTER data type, B-1

explicit transaction model, 2-4

extending, application, 2-11

---

F

features, 1-2

forms and reports, 2-9

---

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 recordsets, 2-2

Jet transactions, 2-4

---

L

large-scale application, 5-1

local table, 2-10

---

M

manual conversion, 4-1

Microsoft Access 97 data types, 3-3

Microsoft Access forms and reports, 2-9

Microsoft Access operators, 3-12

migration process, 2-1

Migration Wizard, 1-3

Migration Workbench, 1-2

modify Microsoft Access database, 2-9

MSysConf table, 5-2

multi-user Microsoft Access application, 2-2

---

N

nValue, 5-2

---

O

ODBC, 2-6

ODBC drivers, 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-3

Oracle reserved words, 3-5

---

P

paragraph tags

PT PrefaceTitle, ix

parameter table, 5-1

performance of ODBC drivers, 5-1

performance of snapshots and dynasets, 5-7

pessimistic locking, 2-3

PL/SQL, 2-5

preparing for migration, 2-7

primary keys and dynasets, 2-7

PT PrefaceTitle, ix

---

Q

qualified queries, 5-7

query, 2-10

---

R

reduce network traffic, 5-7

referential integrity, 2-3

relations with queries, 4-3

relations, deleting within Microsoft Access, 4-2

remote table, 2-10

removing Microsoft Access security, 4-1

repository, 1-2, 1-4

reserved word conflicts, 2-10, 3-5

restricted queries, 5-7

result sets, large, 5-7

result sets, small, 5-7

---

S

security, removing Microsoft Access, 4-1

sequence, 2-5

sequence, definition, B-1

single-user Microsoft Access application, 2-2

snapshot, 2-2

source database, 1-4

Source Model, 1-4

stored procedures, 2-5

supported Oracle data types, 3-1

---

T

table validation, B-4

terminology, 1-3

transactions, 2-4

triggers, 2-5

troubleshooting, 4-1

tuning, 5-1

---

V

validation rules, 3-9