Alex & Access

November 13, 2012

Again on Error 3048: Cannot open any more databases

Filed under: Access — access @ 12:12 pm

Once again I was hit by this error – Cannot open any more databases. It was a complex report, same as last time, all DFirst(), DMax() were removed, any calculated expressions were moved to code behind module. This helped for several months, but application is growing and users start to complain on this error. This time it occurred in same report, but when I make PDF file from 3 reports; I open 3 reports in hidden mode, output all three to PDF and merge into one file. If I comment out one report – it works without errors. Or if I close one form and do export it also works. The only explanation I have so far – Access has limited number of "pointers" to current database, each form/report/code opens more "pointers". So when I open 3 reports and then do export – it reaches "pointers" limit and error occurs.

I my case I changed a query in one or report’s subreport from using subquery to Group By, and this solved the problem. Do not know for how long, but at least I know what to do next. In worst case I just do all calculations in temporary tables, this will made reports simple and require less "pointers ".

Did you have similar experience? Or maybe you have better explanation/workaround for this effect? Let us know!

Blog at WordPress.com.