File Lock

[mnbuckland]

I have a sub routine that extracts data from 1 table, does some calcs and puts results in another table. If I limit the rows to below 5000 the routine works but when I increase the rows to over 10000 it generates a file lock error "3052".
I have increased the MaxLocksPerFile" to 30000 in the registery but this has no effect.
The table I am extracting the data from is a recordset that has been filtered by a query.
I have also tried to delete the records in the target table prior to update but the delete routine also fails when the number of rows exceeds about 5000
Any clues as to what may be causing the problem.

 

[johncallaghan]

Can you post some data so that I could try out your routine?
cheers
john

 

[mnbuckland]

Thanks for your reply. I have overcome the problem by making the recordset a table type instead of a dynaset. Thanks again for the reply