Thanks to those who replied.
This must be a deadly combination of being over 50 and approaching Friday -
but -
1. I have checked on my machine with both one and two instances of my app
running and accessing the same database - I cannot find a single copy of
PDOXUSERS.LCK on the system. (or anything.LCK for that matter).
2. I take it that you can't use BDEADMIN.EXE to set the Private Directory.
Can it only be set programmatically?
3. Is it normal practice to routinely set up a private directory for each
Paradox database - alongside the database directory or within it?
4 Are there any considerations (re Private directories) for multiuser
systems? (I know about NETDIR).
Cheng - I hope your solution is not needed! (beyond me) - these sites have
been running more or less trouble free for 2 years, with their existing BDE
configurations.
Mark
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 5:59 PM
Subject: RE: [DUG]: Lock File too big
>
> This problem occurs when the Private Directory is the same as the
> Application Directory and you are using TQuery's.
>
> In the BDE change the Private Directory and the error goes away
>
>
>
> (Embedded
> image moved [EMAIL PROTECTED]
> to file: 06/10/2000 02:39 am
> pic05450.pcx)
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> cc:
> Subject: RE: [DUG]: Lock File too big
>
>
> Mark,
>
> sounds to me like the app has crashed at some point and the lock file that
> the BDE uses for Paradox tables has been corrupted. If you look for a
file
> called pdoxusrs.lck or paradox.lck (from memory), make sure that your app
> is
> not running anywhere and delete them. These files should only exists
while
> your app is running, and disappear when it's closed.
>
> Regards,
> Mike
>
> > -----Original Message-----
> > From: Mark Howard [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, 6 October 2000 07:13
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: Lock File too big
> >
> > Hello
> >
> > D5 / Paradox
> >
> > I am having problems at 2 sites when they run a quite complex (I think)
> QR
> > report.
> >
> > The symptoms at both sites are not exactly the same and I can't
> re-produce
> > them on my development system. At one site QR will not preview but will
> > print, but then the format of the report bombs seriously after 10 pages
> of
> > a 44 page report. (a landscape report turns to portrait with other stuff
> > happening too). I think there is something wrong with the design of the
> > Query too - it is taking an hour forty five to run.
> >
> > A clue turned up at one of the sites with an error message saying "Lock
> > file too big" when they last tried to run this report. This is a single
> > user site.
> >
> > The report accesses 5 tables only using 5 TQuery's. Can anyone tell me
> > under what circumstances one would expect to get that error message?
Any
> > other suggestions would be gratefully received.
> >
> > The code containing the TQuery's is about 70 lines - is it OK to post
> that
> > amount of code to the list?
> >
> > Mark
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
