>I have come across a known multi user problem with VFP which is:
>
>When 3 or more users try to open the same form at exactly the same time the following error is generated:
>
>Error 1709 - database object is being used by someone else.
>
>
>Microsoft, (in their MSDN article Q170917) say that this error is by design, Ha.
>
>The resolution suggested is to capture the error immediately and RETRY.
>
>I have done this but the RETRY does not attempt to open the database again being that it initial failure occured while it was automatically opening the dataenvironment ( as per Dataenvironment.AutoOpenTables = .T.).
>
>The RETRY gets rid of the 1709 error message BUT DOES NOT re-attempt to open the database as it should do. Consequently, none of the tables/views get opened.
>
>If I wrote code to open all my tables, then I suspect the RETRY would work. However, I have over a 150 forms and do not have the time to write code to open all the remote views in the Dataenvironment.OpenTables method.
>
>Has anyone else overcome this problem, leaving the datenvironment in tact?

I have not encountered this error and I haven't tried to re-create it either.

But unless you expect 100's of users running you application at the same time, (and if you don't get the answer you are looking for) you might want to consider locking you forms while they open so that you just delay anyone trying to open the same form in that time.