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