>This works good, but querying a large number of records takes much more time then if you would open a fox table of the same size. And this method does not let you utilize and indexes in the underlying table. Can you open a SQL table directly instead of querying records remotely?

No - the data engine runs in the server context, not the client context; the indexes are not reflected in result sets. Client/server technology is not ISAM.