Append Method

Appends an object to the collection.

Applies to objects: Connections, Databases, Fields, Indexes, Properties, QueryDefs, Recordsets, Relations, TableDefs, Workspaces.

Syntax

object.Append(addObj)

The Append method syntax has these parts:

Part Description
object Required. A reference to an instance of the object.
addObj Required. An instance of the object to be added to the collection.

Remarks

The Append lets append to the collection an object with a unique Name property. If such object already exists in the collection, the new object won't be added.

The Append method should be called after creating the Field, Index, Property, QueryDef, Recordset, Relation, TableDef object with the CreateField, CreateIndex, CreateProperty, CreateQueryDef, OpenRecordset, CreateRelation, CreateTableDef methods respectively and after assigning all necessary properties to the created objects. After calling the Append method the corresponding objects (except Property ) will appear in the database.

Example

Examples for most common cases.

 

See Also

Connections Object, Databases Object, Field Object, Fields Object, Index Object, Indexes Object, Property Object, Properties Object, QueryDef Object, QueryDefs Object, Recordset Object, Recordsets Object, Relation Object, Relations Object, TableDef Object, TableDefs Object, Workspaces Object, Name Property, CreateField Method, CreateIndex Method, CreateProperty Method, CreateQueryDef Method, CreateRelation Method, CreateTableDef Method, OpenRecordset Method.