Try

oUsers.Open "SELECT * FROM users WHERE <whatever>", oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdText   

>
>Based on your help I now have a working model. I do have one last question however. (At least I hope its the last.)
>
>The line
>

>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?
>
>Thanks
>- Don
>
>-btw I will explore the .Net option as soon as I have a few minutes to spare.