Access Database Design and Programming, Second Edition

TableDef Object

Collections

Property	Type	Version	Description
Fields	Fields	3.0/3.5	Collection of fields in this TableDef object
Indexes	Indexes	3.0/3.5	Collection of indexes associated with this TableDef object
Properties	Properties	3.0/3.5	Collection of Property objects

Methods

Method	Parameters	Returns	Version	Description
CreateField	[Name], [Type], [Size]	Field	3.0/3.5	Creates a new Field object
CreateIndex	[Name]	Index	3.0/3.5	Creates a new Index object
CreateProperty	[Name], [Type], [Value], [DDL]	Property	3.0/3.5	Creates a new user-defined Property object
OpenRecordset	[Type], [Options]	Recordset	3.0/3.5	Creates a new Recordset object
RefreshLink		Sub	3.0/3.5	Updates connection information for an attached table

Properties

Property	Type	Version	Description
Attributes	Long	3.0/3.5	Miscellaneous characteristics of the TableDef object
ConflictTable	String	3.0/3.5	Name of table containing records that conflicted during replica synchronization
Connect	String	3.0/3.5	Data source for the TableDef
DateCreated	Variant	3.0/3.5	Date and time when the table was created
LastUpdated	Variant	3.0/3.5	Date and time when the TableDef was last changed
Name	String	3.0/3.5	Name of the TableDef
RecordCount	Long	3.0/3.5	Number of records
ReplicaFilter	Variant	3.5	Indicates which records to include in a partial replica
SourceTableName	String	3.0/3.5	Name of a linked table’s original source table.
Updatable	Boolean ...