TableDef

Methods

Name	Returns	Description
CreateField	Field	Creates a new Field object.
CreateIndex	Index	Creates a new Index object.
CreateProperty	Property	Creates a new user -defined Property object.
OpenRecordset	Recordset	Creates a new Recordset object.
RefreshLink		Updates the connection information for a linked table.

Properties

Name	Returns	Description
Attributes	Long	Sets or returns a value indicating characteristics of an object.
ConflictTable	String	Returns the table name that contains conflicts that occurred during synchronization.
Connect	String	Sets or returns a value providing information about a data source for a TableDef .
DateCreated	Variant	Returns the date and time when the table was created. Read-only.
Fields	Fields	Collection of Field objects in a TableDef object. Read-only.
Indexes	Indexes	Collection of Index objects associated with a TableDef object. Read-only.
LastUpdated	Variant	Returns the date and time of the most recent change to an object. Read-only.
Name	String	Returns the name of this object.
Properties	Properties	Collection of Property object. Read-only.
RecordCount	Integer	Returns the number of records in the Recordset . Read-only.
ReplicaFilter	Variant	Indicates which records to include in a partial replica.
SourceTableName	String	Sets or returns the name of a linked table's original source table.
Updatable	Boolean	Returns whether the definition of the table can be changed. Read-only.
ValidationRule	String	Sets or returns a value indicating whether a field contains valid data.
ValidationText	String	Sets or returns a value indicating a message if an entered value is invalid