Dynamic Properties
Here are the dynamic properties of an ADOX Table object in Jet. These properties might change when you work with a different Jet version:
  • Jet OLEDB:Table Validation Text
  • Jet OLEDB:Table Validation Rule
  • Jet OLEDB:Cache Link Name/Password
  • Jet OLEDB:Remote Table Name
  • Jet OLEDB:Link Provider String
  • Jet OLEDB:Link Datasource
  • Jet OLEDB:Exclusive Link
  • Jet OLEDB:Create Link
  • Jet OLEDB:Table Hidden In Access

    Note these dynamic properties of an ADOX Column object in Jet:

  • Autoincrement
  • Default
  • Description
  • Nullable
  • Fixed Length
  • Jet OLEDB:Column Validation Text
  • Jet OLEDB:Column Validation Rule
  • Jet OLEDB:IISAM Not Last Column
  • Jet OLEDB:AutoGenerate
  • Jet OLEDB:One BLOB per Page
  • Jet OLEDB:Compressed UNICODE Strings
  • Jet OLEDB:Allow Zero Length
  • Jet OLEDB:Hyperlink

    These are the dynamic properties of an ADOX Column object in SQL Server:

  • Autoincrement
  • Default
  • Fixed Length
  • Nullable
  • Primary Key
  • Unique

    There's one dynamic property of an ADOX Table object in SQL Server:

  • Temporary Table