>>
RS.CursorLocation = adUseClient
>>RS.LockType = adLockPessimistic
>
>Whew. That worked. It works with and without the adUseClient, and locktype.
Because these are the default values of disconnected recordset.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com