Hi;
I was wondering how can one retreive Field name in a db (column name) (access or Sql) .
In clearer terms , suppose you have a DB with one or more tables... we are only interested in "TableX" ... which has
Z number of fields. I want to be able to retrieve those fields name
trough VB code ... thus having a progam that does the following :

- user provides table name and dB name
- Program returns :

" this table contains Z Fields "
" here are the fields names "
"field1"
"field2"
.... etc
any help would be greatly apreciated