I have a project that needs to integrate with older SBT accounting program that uses 2.X tables. It will be a totally separate program only accessing the data used by SBT. The advise I seek is what technique I should use to access the data for both read/write.

Since VFP3 I try exclusively to use updateable views as data access on all my forms. But since I have to access the SBT data as free tables instead of adding it in the database, I can't create updateable local views (can I?). Thus, in displaying filtered data in something like a grid my only options are to:

1. Use "SET FILTER" which is dog slow.
2. SELECT-SQL but this creates read-only access.

Any good solution to this problem I'm missing? TIA.