CreateTableDef Method


Creates a new TableDef object (Microsoft Jet workspaces only).


Set tabledef = database.CreateTableDef (name, attributes, source, connect)

The CreateTableDef method syntax has these parts.




An object variable that represents the TableDef object you want to create.


An object variable that represents the Database object you want to use to create the new TableDef object.


Optional. A Variant (String subtype) that uniquely names the new TableDef object. See the Name property for details on valid TableDef names.


Optional. A constant or combination of constants that indicates one or more characteristics of the new TableDef object. See the Attributes property for more information.


Optional. A Variant (String subtype) containing the name of a table in an external database that is the original source of the data. The source string becomes the SourceTableName property setting of the new TableDef object.


Optional. A Variant (String subtype) containing information about the source of an open database, a database used in a pass-through query, or a linked table. See the Connect property for more information about valid connection strings.



If you omit one or more of the optional parts when you use the CreateTableDef method, you can use an appropriate assignment statement to set or reset the corresponding property before you append the new object to a collection. After you append the object, you can alter some but not all of its properties. See the individual property topics for more details.

If name refers to an object that is already a member of the collection, or you specify an invalid property in the TableDef or Field object you're appending, a run-time error occurs when you use the Append method. Also, you can't append a TableDef object to the TableDefs collection until you define at least one Field for the TableDef object.

To remove a TableDef object from the TableDefs collection, use the Delete method on the collection.