Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1709
Message
De
08/02/1999 14:07:36
 
 
À
04/02/1999 11:15:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00183899
Message ID:
00185204
Vues:
24
Hi Erik.

>One of my applications has begun throwing 1709 (Database object is in use by someone else) often enough to make my users want to kill me.

I haven't run into this personally, but Bruce Allen of Dallas has and told me about it. The problem appears to be caused by a lock of the view record in the DBC while the view is being opened. If 2 users try to open the view at exactly the same time, this error can occur.

Here are some suggestions until MS fixes this bug:

- If you're not already, how about opening the views NODATA so the time to open it (and thus lock the record) is minimized.

- Your users won't like this (although they'll like it better than "Mismatched Pushjmp/ Popjmp" <g>), but when this error occurs, you could tell them to try again and then release the form and RETURN TO , where is the name of the routine containing your READ EVENTS.

- You could improve the second idea by instantiating a timer before releasing the form. When the timer fires, it re-runs the form, then disables itself. This way, the user doesn't have to manually re-run the form.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform