Class TableDef (DAO VBA)
A TableDef object represents the stored definition of a base table or a linked table (Microsoft Access workspaces only).
Class Database gives access to class TableDef.
Dim tbl as TableDef
Set tbl = Workspaces(1).Databases(1).TableDefs(Item:=1)
Methods
OpenRecordset - Creates a new Recordset object and appends it to the Recordsets collection.
Dim rst As DAO.Recordset
Set rst = tbl.OpenRecordsetCreateField - 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).
RefreshLink - Updates the connection information for a linked table (Microsoft Access workspaces only).
Properties
Fields (Default member) - Returns a Fields collection that represents all stored Field objects for the specified object.
Attributes sets or returns a value that indicates one or more characteristics of a TableDef object.
ConflictTable returns the name of a conflict table containing the database records that conflicted during the synchronization of two replicas (Microsoft Access workspaces only).
Connect sets or returns a value that provides information about a linked table.
DateCreated returns the date and time that an date was created (Microsoft Access workspaces only). Read-only Variant.
Indexes returns an Indexes collection that contains all of the stored Index objects for the specified table.
LastUpdated returns the date and time of the most recent change made to an date. Read-only Variant.
Name returns or sets the name of the specified object.
Properties returns the Properties collection of the specified object.
RecordCount returns the total number of records in a TableDef object.
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.
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).
Related Classes
Field - A Field object represents a column of data with a common data type and a common set of properties.
Fields - A Fields collection contains all stored Field objects of an Index, QueryDef, Recordset, Relation, or TableDef object.
Index - Index objects specify the order of records accessed from database tables and whether or not duplicate records are accepted, providing efficient access to data. For external databases, Index objects describe the indexes established for external tables (Microsoft Access workspaces only).
Indexes - An Indexes collection contains all the stored Index objects of a TableDef object (Microsoft Access workspaces only).
Properties - A Properties collection contains all the Property objects for a specific instance of an object.
Property - A Property object represents a built-in or user-defined characteristic of a DAO object.
Recordset - A Recordset object represents the records in a base table or the records that result from running a query.