I think you may be out of luck on this - although I am guessing you are processing some very large data sets to get to the limit. Can you pre-filter in some way? Or reduce the number of fields perhaps in order to fit in more records?
This reference my provide some useful background. There is a post some way down that lists the technical limits of Access.
I hope this is useful even though not an obvious solution.