Purpose
Returns a 2-dimensional array with all the values of the TableDefType Enum.
Description
Every row in this array has 2 values:
• | The numeric value of the Enum value |
• | A text representation of this value |
This array can be used to validate values, and to print a ,meaningful description of the values during debugging
You can pass this array tro the DaoEnum2Str() function to convert the value of an Enum to a string
Constant | Description |
dbAttachExclusive | For databases that use the Microsoft Jet database engine, the table is a linked table opened for exclusive use. You can set this constant on an appended TableDef object for a local table, but not on a remote table. |
dbAttachSavePWD | For databases that use the Microsoft Jet database engine, the user ID and password for the remotely linked table are saved with the connection information. You can set this constant on an appended TableDef object for a remote table, but not on a local table. |
dbSystemObject | The table is a system table provided by the Microsoft Jet database engine. You can set this constant on an appended TableDef object. |
dbHiddenObject | The table is a hidden table provided by the Microsoft Jet database engine. You can set this constant on an appended TableDef object. |
dbAttachedTable | The table is a linked table from a non-ODBC data source such as a Microsoft Jet or Paradox database (read-only). |
dbAttachedODBC | The table is a linked table from an ODBC data source, such as Microsoft SQL Server (read-only). |
Returns
Array
See Also