(Paradox is set to run in network mode)
When I run two SQLs Back to Back on a paradox table, PDOXUSRS.LCK file gets created! The problem is if I run these two sqls over and over the PDOXUSRS.LCK keeps growing and growing. BUT if I only run one SQL over and over, the PDOXUSRS.LCK does not grow. Why is this PDOXUSRS.LCK growing when two sqls run back to back multiple times. The other problem is that because the file keeps growing. This file reaches 25 MEGS. and it busts. Errors start appearing!
These queries are simple select queries.
(Select * from xxx where TDdate > 1/15/95 )