|
Hi
Mark,
I've
encountered "lock file too big" problem a few months back, this
usually happens when the app opens a table, and then open a query based on the
current record of the table (there is an article about this on the web, I can't
remember the URL). I solved the problem by using a saperate session for the
problem area, assign to that session its very own private dir (at run time, you
can see the lock files are placed on both the private dir and working
directory).
HTH
Cheng
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
|
