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
|