Sounds nice isn't it? "Remote views to local tables" :-).

I don't know if this help somehow to avoid table corruption. Maybe the ODBC/OLE DB driver keeps itself the table open as long as the client connection for speed reasons?
The one thing I do know is that you can have an extra super server, and a single workstation is enough to corrupt tables/indexes.


>Dorin,
>Instead of local views you could use remote views to local VFP tables. It'd sort of emulate MSDE service based operation.
>Cetin
>
>>Right, even if you use local view, after every requery() you must have code that close the source table, because Foxpro leaves it open, so it can become corrupted if something go wrong at workstation level.