oUsers.Open "SELECT * FROM users WHERE <whatever>", oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdText>
>oUsers.Open "users", oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdTable >>opens the table with all records available. We then have to loop down through the table to find the record we want to edit. Is there a variation on this that would allow the open to function like a "select ... where ..." so we could open directly to the record in question?