Hi all. I'm running into problems with the main data entry form in my project(VFP6.0 SP3 front-end, SQL Server 7 back-end). I have been trying to replace the Remote Views with SQL-PT, and think I finally figured out how to make buffering work with the pass through.

However, I have realized two problems with this form now.

1.) I have filled my main table with 20,000 test records (25 fields/record, no memo fields). It now takes almost 10 seconds to load the cursor, using Syncronous execution. (I can't get Asynchronous execution to fly with buffered tables). This isn't necessarily a problem in itself, but having to wait 10 seconds every time the cursor is refreshed (to accomodate other multiple user data entry) is too long. I've considered only loading a subset of the table, which would work for this project, and it led me to consider the second problem.

2.) The current DB is in Access. We were moving to VFP/SQL Server to accomodate increased table sizes and speed up the system. In the current Access system, when a user makes a change to a record, as soon as that user moves off that record, the change is reflected in the DB, (which would lead me to believe it is record buffered). However, it's also reflected on all other workstations, even though they didn't do any sort of refresh on the recordset. This is what I'm confused about. It seems almost as if the recordsets aren't buffered at all, or each time they move to a new record, that particular record is re-loaded. Can somebody explain this to me?

(This was a bit wordy, please let me know if you need more info on either system...)

Thanks!