Well you can probably do it one of two ways. I don't
have the exact syntax but I can prehaps point you in
the right direction.
Use an SQL Query Statement
Select Column1 From TableDef Where TableName =
"YourTableName";
Or you can do the following and try to access it this
way.
Set dbDatabase =
Workspaces(0).OpenDatabase(dbPathPrefix &
DataBaseName)
ColumnName =
dbDatabase.TableDefs.["TableName"].Fields(1).Name
Again the above syntaxes might not be spot on but they
will be close and should help you narrow it down a bit quicker.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping