On Tue, 09 Sep 2003 09:30:17 -0400 Dennis Fleming <[EMAIL PROTECTED]> wrote:
> Have you Set Lock Tablename ON for the same table you are trying to access > on another PC? Also, the user that locks the DB may have left it locked > (check your code). > > Dennis > ***** > > At 02:01 PM 9/9/2003 +0200, you wrote: > >hello! > > > >In my multi user DB, I have the message "waiting to access to a > >required resource 25%" and keeps until I push cancel button. I try to > >use set wait, set interval with differents values, but the message still > >appears. In my configuration uses set rowlocks on. > >There is a standard configuration to avoid this problems? > >Why the message not do retries? > > > >tx for your answers > > > >best regards > > > >Ramon Guardiola > >fermatic Three system > > > > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Fax: 570 775-9797 > No, I don't block any table , I write At the begginning of source code: SET ECHO ON SET ERROR MESSAGES ON SET MESSAGES ON DISCONNECT SET QUOTES = ' SET ROWLOCKS ON SET MULTI ON CONNECT &vcop set currency ' ' pref 2 B SET FEEDBACK ON SET WHILEOPT OFF SET ECHO OFF SET MESSAGES OFF SET ERROR MESSAGES OFF SET ZERO ON It's only in a process that we call "nigth process" where we have this problem. In this process we collect all the company invoices and process stadistics and so on. We use for that a temporary tables (one for each sales office -10 sales office we have-.) and it's for that why I don't understant Best Regards Ramon Guardiola fermatic Three system
