Make reference to a field in ADO

Hi everyone.

How i do to make reference to fiel in ado that the name is like
"MYTABLE.MYFIELD" ?

if i put somethind like this

dim rs as ADODB.RECORSET

' *** Initializes connection, ejecute the query, etc.
.
.
.
.
x = rs("MYTABLE.MYFIELD")


i get an error.

If put this in the query: "MYTABLE.MYFIELD AS OTHERFIELD" and i make the
reference like rs("OTHERFIELD") it's works, but i don?t wan to make it.
it is the only way ?????

Thanks

You can use the index value, rs.Fields(0)

Select field1, field2 from table

rs.Fields(0) => field1
rs.Fields(1) => field2

Unless you have more than on field by the same name (which I think might return an ADO error), just use the field name. No need to qualify it with the table name.