[DUG]: Lock File too big

[Mark Howard]

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