how to read the MDB-Table description from WORD?

[Baloo]

hi all

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.

[Hack]

You want

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

[Baloo]

thanks, Hack!

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

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.

[RobDog888]

This has always worked for me...

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

[Baloo]

RobDog888, thanks a lot for your attention

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

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.

[Baloo]

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

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.

[RobDog888]

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.