TableDef members (DAO)

Article
03/18/2022

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.