>Thank you Fred for joining in,
>I tried that a prior to posting this thread. Although I did not get the same error, I did get a different error. I got an OLE IDISPATCH error that advised me that I reached either EOF or BOF. But that is wrong also. Becasue the record that I am SELECTing for via the WHERE clause is a valid record. Any other thoughts?
>
Neil,
What's the size of custid field? If it's more than 6 characters, try to pad '765583' to the size of the field with spaces.
rs=oConnection.Execute([SELECT * FROM arypat01 WHERE custid= '765583 '] )
--sb--