Opening a Recorset with adCmdTable option

[Giddygoat]

When I open a recordset with the adCmdTable option does the whole table get loaded into memory?

With rs
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "A_BIG_TABLE", sConnect, , , adCmdTable
End With

Or does ADO only get the daya when I ask for it, i.e.

With rs
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "A_BIG_TABLE", sConnect, , , adCmdTable
while not .eof
' Do stuff
.movenext
wend
.close
End With


Hope you can help

John