Part III: More-Advanced Access Techniques
652
TABLE 18.2 (continued)
Property Description Select Crosstab Update Delete Make-Table Append
Source
Database
External database
name for all
tables/queries in
the query
XX X X X X
Source Connect
Str
Name of applica-
tion used to con-
nect to external
database
XX X X X X
Record Locks Records locked
while query runs
(usually action
queries)
XX X X X X
Recordset Type Which records
can be edited:
Dynaset, Dynaset
(inconsistent
updates), or
Snapshot
XX
ODBC Time-out Number of
seconds before
reporting error for
opening DB
XX X X X X
Filter Filter name loaded
automatically with
query
X
Order By Sort loaded
automatically with
query
X
Max Records Max number of
records returned
by ODBC
database
X
Orientation Set view order for
fields from left-to-
right or right-to-
left
XX X X X X
Subdatasheet
Name
Identify subquery X X X X X
Link Child
Fields
Field name(s) in
subquery
XX X X X
Link Master
Fields
Field name(s) in
main table
XX X X X
