Field Name in Access database

Does anybody know how to get the field names of a table in an Access database?
I am using rs!fieldName, but it does Not work.
Any suggestions??
Thanks
Rav
[191 byte] By [locus86] at [2007-11-18 5:52:02]
# 1 Re: Field Name in Access database
Check out this thread ... http://www.dev-archive.com/forum/showthread.php?s=&threadid=219871&highlight=fieldname

Also search on ADO and/or DAO in the VB forum for specific connection code ...
M Owen at 2007-11-9 13:33:33 >
# 2 Re: Field Name in Access database
..Or

for i = 0 to rs.fields.count - 1
msgbox rs(i).name
next i

..Or using openschema method from the connection object

set rs = cn.openschema(adschemacolumns)

do until rs.eof

if rs("TABLE_NAME") = <The table name here> then
msgbox rs("COLUMN_NAME")
end if

rs.movenext
loop

set rs = nothing
Thread1 at 2007-11-9 13:34:32 >