Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1709: Database object is being used by someone els
Message
From
25/02/1999 10:29:27
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00191088
Message ID:
00191426
Views:
37
>Opening forms simultaneously causes problems for me too - easily reproduced by opening the form twice. I get error 2005, but the symptoms are the same.
>
>I solved it by embedding the DO FORM inside a retry loop along the lines of:-
>
>
>* preserve the old error handler.
>oldEHandler = on("Error")
>
>* you should really preserve the reprocess too
>set reprocess to 2 seconds
>
>* retry counter...
>nRetries = 0
>
>* ...and maximum - you may want this tweakable by your program, so
>* DON'T use a constant
>nMaxRetries = 6
>
>* set the error code...
>e = 0
>
>*...and force the random number generator to seed (see help)...
>=rand(-1)
>
>* Here we go:-
>on error e = error()
>do form (fName) NAME .....etc
>do while (e <> 0) and (nRetries < nMaxRetries)
>  * you might want a 'working...' message in here...
>  nRetries = nRetries + 1
>  * delay for a while...
>  =inkey(.2+rand())
>  e = 0
>  do form (fName) NAME .....etc
>enddo
>
>* restore the old error handler...
>on error &oldEHandler
>
>
>
>This works fairly well, although you will need to tweak it for your particular network (or if you want to get flashy, get it to tweak itself). I find it best to put in a 'retrying (n) of (m)' message to keep users occupied.
>
>Hope this helps.


Excellent suggestions, All. Thanks for your help.
Previous
Reply
Map
View

Click here to load this message in the networking platform