TableDef members (DAO)

Applies to: Access 2013, Office 2013

A TableDef object represents the stored definition of a base table or a linked table (Microsoft Access workspaces only).

Methods

Name

Description

CreateField

Creates a new Field object (Microsoft Access workspaces only). .

CreateIndex

Creates a new Index object (Microsoft Access workspaces only). .

CreateProperty

Creates a new user-defined Property object (Microsoft Access workspaces only).

OpenRecordset

Creates a new Recordset object and appends it to the Recordsets collection.

RefreshLink

Updates the connection information for a linked table (Microsoft Access workspaces only).

Properties

Name

Description

Attributes

Sets or returns a value that indicates one or more characteristics of a TableDef object. Read/write Long.

ConflictTable

Returns the name of a conflict table containing the database records that conflicted during the synchronization of two replicas (Microsoft Access workspaces only). Read-only String.

Connect

Sets or returns a value that provides information about a linked table. Read/write String.

DateCreated

Returns the date and time that an object was created (Microsoft Access workspaces only). Read-only Variant.

Fields

Returns a Fields collection that represents all stored Field objects for the specified object. Read-only.

Indexes

Returns an Indexes collection that contains all of the stored Index objects for the specified table. Read-only.

LastUpdated

Returns the date and time of the most recent change made to an object. Read-only Variant.

Name

Returns or sets the name of the specified object. Read/write String.

Properties

Returns the Properties collection of the specified object. Read-only.

RecordCount

Returns the total number of records in a TableDef object. Read-only Long.

ReplicaFilter

Sets or returns a value on a TableDef object within a partial replica that indicates which subset of records is replicated to that table from a full replica. (Microsoft Access workspaces only).

SourceTableName

Sets or returns a value that specifies the name of a linked table or the name of a base table (Microsoft Access workspaces only).

Updatable

Returns a value that indicates whether you can change a DAO object. Read-only Boolean.

ValidationRule

Sets or returns a value that validates the data in a field as it's changed or added to a table (Microsoft Access workspaces only).Read/write String.

ValidationText

Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting (Microsoft Access workspaces only). Read/write String.