Robert,

I'd try to set REPROCRES TO 1 or 2..

You're trying to stress the system here by creating a situation that is vunerable for deadlock. Even if you switch to SQL server, which will be better in handling high concurrency situations like this, you can encounter these kind of deadlocks where two transactions are waiting for a lock.

VFP is not particulary suited for high online transaction processing this way. It is fine if you keep the number of transactions low and/or accept/use a strategy where you deal with failed transactions. If you're looking for high volume processing, indeed, using SQL server might be better as a backend database.

Walter,


>I added Set Reprocess to Automatic and got a dead lock, one screen showed 'Attempting to lock... press ESC to cancel' while the other 'Record not available... please wait'.
>set reprocess to 2 desn't help either. besides 'file in used' problem, I also got Open File screen. just wonder if I switch to SQL-type of database, it will be more solid.
>
>thanks for the help.
>
>Robert