how to read the MDB-Table description from WORD?

hi all :wave:

I mean a description, that you can see by MDB-Open - in main window of MDB (sorry for this explanation:))
There are for example: first column = TableName, second = Description, third = Modified etc... in this main-window of MDB.

I can read table-name - CurrentDb.TableDefs("Table1").Name and etc...
but I can't find there "Description":(

could you pls help me!

kind regards,
Baloo.

You want

Code:

---

.Fields("Name").Properties("Description")

---

thanks, Hack!

But I don't need to read description of TableFields, I need description of the whole table.
I've also tried:

VB Code:

CurrentDb.TableDefs("Table1").Properties("Description")

But there aren't such item in this collection "Properties(...)" for TableDef:(

Could you be so kind to find this description exactly for whole table?

kind regards,
Baloo.

This has always worked for me...

VB Code:

MsgBox Application.CurrentDb.TableDefs("Table1").Properties("Description").Value

RobDog888, thanks a lot for your attention:)

but I've checked the whole collection "Properties(...)" for TableDef:

VB Code:

Dim propItem As Property
      For Each propItem In jetDB.TableDefs(strTableName).Properties
         Debug.Print propItem.Name & " = " & propItem.Value
      Next

and I've got only these Properties:
Name = Table1
Updatable = False
DateCreated = 06.12.2005 11:28:22
LastUpdated = 16.02.2006 16:41:56
Connect = dBase III;HDR=NO;IMEX=2;DATABASE=C:\MyTables
Attributes = 1073741824
SourceTableName = Table1.dbf
RecordCount = -1
ValidationRule =
ValidationText =
ConflictTable =
ReplicaFilter =
Orientation = 0
OrderByOn = False
DefaultView = 2
there is no "Description" in this list :(

Maybe exist another way to get this "Description" for Table?

kind regards,
Baloo.

o sorry, RobDog888, I didn't described all details, you was absolutely right:
I've tried it in Access:

VB Code:

Application.CurrentDb.TableDefs("Table1").Properties("Description").Value

and in Access IT WORKS!:)
But I'm working in WORD.VBA and trying to read MDB from WORD.VBA
And threre is no such Property in WORD as stated previous message.

Could you pls say - how can I read this Property "Description" for Table exactly from WORD?

kind regards,
Baloo.

Sure, just add a reference to Access xx.0 Object Library in your Words VBA IDE and use some code to create a new instance of Access application and open you db. Then the code I posted will work.