Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1709 object in use error
Message
 
To
27/05/2002 11:13:32
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00661693
Message ID:
00661732
Views:
22
Stephen,

>
>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, (MSKB #Q170917) say that this error is by design, Ha.
>
>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.).

What!!?

I can't believe this, I've never had this error and am not willing to accept this as "by design", as most of
us do MU-Design and this can't mean "multi-user up to three". Is there something special about the tables / Views?

....

OK, I've just read the article. They say: "...when the database container is being manipulated"

That leads to the philosophical question: "when is a database-container manipulated?"

I havn't tested but I guess that can't be just opening a table. Creating a table in the database, creating a view, OK that's definitively manipulating the DB-Container.

Are You creating temporary views or using parameterized ones?. Are You creating temp-tables that maybe accidentally become members of the DB-Container?

HTH
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform