>Hi Rober,
>>
>>Is this a multi-user app? What you might be getting is a misreported "Database object is being used by someone else. (Error 1709)" - you'll sometimes get this if two (or more) users attempt to open the form at the same time: what's more it won't always report 1709 (my VFP5a likes to report error 2200 whatever that is).
>>
>>Just a thought
>
>It is definately a multi-user app. I have a built-in trap/retry for Error 1709 (as well as 3, 108, 109, 1502, and 1995). I've never seen Error 2200 though. Interesting thought.


I tested the eventual error handler with three PC's on my desk and a lot of simultaneous enter-key pressing (no, I haven't got three arms - one PC was a slow one so I'd start that first).

I received all sorts of errors - once I put a specific error handler in for 1709 I discovered that all sorts of other errors seemed to cascade from it.

I eventually had to add a loop around the DO FORM... with a number of retries plus SET REPROCESS... which retries regardless of error code. Works fine.

This problem occurs on all my multi-user apps - it must be my programming style (or lack of it).