I have encountered a problem with a fairly hefty calculate program that is giving me error 3014: Can't open any more tables.

I am closing the recordsets as soon as they are done and the MS Help says this error is caused by Jet's way of managing transaction processing but there is no transaction processing involved, is there anything else I can do?

I am using VB6 SP3, Access 2000, DAO 3.6, Jet 4