Appends an object to the collection.
Applies to objects: Connections, Databases, Fields, Indexes, Properties, QueryDefs, Recordsets, Relations, TableDefs, Workspaces.
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. |
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.
Examples for most common cases. |