I am, thanks alot. I do have another question that hopefully you can shed some light on or lead me in the right direction.

I notice that the FIRST time I do a SELECT from the foxpro command window using either a remote view, ADO or DSN connection that it appears foxpro sequentially goes through the entire remote SQL database. I say this because the FIRST select on the database is slower and I can see the counter in the status bar iterate through the entire table. After the first select, subsequent selects are fast and I do not see the counter.

If I quit foxpro, the process starts over, that is, the initial select does the above. I checked my index on the SQL side and they are their. Even the most simple select does this.

Any insight?

Thanks,
bob