I think your asking for a lot of trouble when allowing multiple table access in a multi-user data environment.

If you must structure your system as you've described, you may want to at least set up buffers and record locks to allow only view to n-person, when first-person has change access...




>Dear Experts,
>
>I developed a small application in vfp8, in that i using all the commands in
>Sql Format (For Eg. Instead of Append blank i m using Insert into Statement, and in the palce of 'Seek' i m using 'Select' statement with Cond. Etc., I m not using Data Environment, open the table on demand basis).
>
>now i m most of the time facing Table Curruption probs.
>whe i trying open gives the error that 'Not A Table'.
>then i add 'Set Table Validate to 0', after that working fine
>for some time Now it satarted again. this time i set table
>validate from 0 - 3, but no result.This happends only for
>the table which is using in multi users.
>
>(Egs. Invoice table,purchase table and item masters table etc...)
>Now i m really confused that will Vfp really support Sql
>satament or shall i go back to Vfp traditional command
>like 'Append Blank' and 'Replace' statatement.
>
>In addtion to this for secuirty pupose i m using
>'.DBT' instead of '.DBF' Table Extensions.
>
>Eg. My insert statment is like this
>Insert Into c:\Dev\Data\ABC.DBT(Fild1,Fild2,Fild3) Values (X,Y,Z ).
>
>Pls help me where i m missing.
>
>Thanks in advance
>Regards
>Abdulla