>John--
>
>>You probably need the fully qualified dbo name in your sql statement. It might be as simple as select ... from dbo.insured ....
>
>
>I posted this problem on the Advantage.ODBC newsgroup. The first response asked if I had used a qualified reference. If I had, I was told to remove the qualification.
>
>Does Advantage use the dbo.MyTable syntax/semantices?
>
>
>Tim

Not sure. I've only played around with it a few times.