i want to know the table is hidden.
How to use ADO retrieve MSAccess attribute ?
Hot Topic
- Loop causing MS Word freeze
- Using VBA macro to locate next free column on worksheet
- formula for this problem
- VBA Excel: PivotTable Visibility and PivotField inclusion problems
- personalized command bar disappears when minimizing excel
- Setting back color in MSComctlLib.TreeCtrl.2 control using VB for MS Access
- Setting the Directory at GetOpenFileName
- VBA Excel - Using The "For each" function with a string
- Filter string in GetOpenFilename method
- Help with interface?
Microsoft ISV
- MergeSort for Double Arrays
- Urgent HELP!!!!! VB in MS Excel
- Run-Time Error '3061' - Too few parameters. Expected 1.
- delete blank line in table cell
- Using VBA macro to locate next free column on worksheet
- Using Tabs in MSComctlLib.TreeCtrl.2 control
- Supply partial variables
- MS Office document and image writer print driver
- Run Time Error 9 when Calling a Userform
- what is wrong with this formula? *9 Views & no one knows?*
How to use ADO retrieve MSAccess attribute ?
Marimuthu_r
There is no direct method of ADO to list table property. If you want to stick with ADO, then you have to include the ADOX library (ADO extension), from there you can have access to the database schema.
Alternatively, you can use DAO to list the object in the database, in DAO there is a property named TableProperties.
Hope this can help.