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 ...

Get Access Database Design and Programming, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.