Data Property Page (ADP)

(Microsoft SQL Server 2000 only.) Applies to tables, views, single-statement stored procedures, and in-line functions. Shows properties about filtering, ordering, and subdatasheets.

Table Name

Appears only if you are working on a table. Shows the name of the table. If you are working in a database diagram and more than one table is selected in it, only the name of the first table is visible.

Object Name

Applies only if you are working on a view, single-statement stored procedure, or in-line function. Shows the name of the object you are working on.

Filter

Shows client-side selection criteria — criteria applied after the result set is returned from the database. This property is a string expression consisting of a WHERE clause without the WHERE keyword.

Order By

Shows client-side sorting criteria — sorting criteria applied after the result set is returned from the database. This property is a string expression that is the name of the field or fields on which you want to sort records. When you use more than one field name, separate the names with a comma (,). If you want to sort records in descending order, type DESC at the end of the string expression.

Subdatasheet Name

Specifies or determines the table or query that is bound to the subdatasheet. Choose [Auto] to indicate that Access will use existing relationships in the database to determine which table to bind to the subdatasheet.

Link Child Fields

Shows the list of linking fields in the subdatasheet. The fields you list here should coincide with the fields you supply in the Link Master Fields control.

Link Master Fields

Shows the list of linking fields or controls in the table, view, stored procedure, or in-line function containing the subdatasheet. The fields you list here should coincide with the fields you supply in the Link Child Fields control. Each coinciding pair of (master, child) fields do not have to have the same name, but they must contain the same kind of data and have the same or compatible data types and field sizes.

Subdatasheet Height

Shows the default height to display in the subdatasheet. If the subdatasheet contains more rows than the default height accommodates, the subdatasheet appears with a vertical scrollbar.

Subdatasheet Expanded

Indicates the saved state of all subdatasheets within the table, view, single-statement stored procedure, or in-line function. Yes means expanded, No means unexpanded.

Default View

Shows the view used to display the subdatasheet when the users opens the object or embeds it as a subform or subreport. Your choices are Datasheet, PivotTable, or PivotChart.