Eric,

Thanks for your help.

>With rstPhonesSQL
> .CursorType = adOpenDynamic
> .LockType = adLockOptimistic
> .CursorLocation = adUseClient
> .Open "SELECT * FROM Phones ORDER BY name ASC", cnnPhoneSQL
> End With


I tried it but still getting the same error. Any other suggestion?


Thanks,
Sergio