Hi Kile,

There may well be other factors at work here, but. . .

*IF* the only reasons for moving to VFP/SQL Server are
1) increased table sizes
2) speed

. . . then you should know that
a) each table in VFP can hold 2GIG and the memo fields related to any file are a separate 2GIG

b) VFP is THE fastest, and SQL Server will *NOT* meet the speed capabilities of VFP by any means, though I suppose that it WILL beat ACCESS handily.

SNIP

Cheers,

Jim N


>
>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!