I'm working with a legacy database and associated VBA code. I first it split it out to have a backend and front end (FE). The FE only has reports, queries, a very few tables, and forms.
I'm getting the beloved "cannot open any more databases" when attempting to print a report which has several (7) subreports.
Of course, this is with a database with linked tables but not that many (about 15).
I've already replaced DLOOKUP statements with ELOOKUP but didn't solve the problem. WIll replacing these subreports with logic in as a standard report help? In another situtation, I split the report into 3 different reports but the users are rejecting that as an solution. I'm on Access 2010 and 2013 (must run on both). I'm new at this so any advice tuned for the new guy would be most appreciated.