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