Sounds like your middle tier is too dependent on SQL. Can you change it to receive data to do its calculations/intelligence with instead of going back to the server? Or at least split out the intelligence so that VFP can call the necessary methods.
>A novel idea except that I have a middle tier with intelligence that is needed when editing. The middle tier can only access records that are written to the sql server so the client cannot cache the records because the middle tier couldn't see them.