Do you get these errors if you are using the sample Northwind database? Is
there anything else that you can tell us about your database that experiences
such errors? For example, are you opening recordsets in code (perhaps in a
loop), but failing to close them and set the recordset variable = Nothing at
the end? Do you have lots of images that are included in a report, and the
error occurs when previewing or printing the report?
it doesnt tend to happend when viewing reports but sometimes if trying to
open a report from the tab form it will, but then also does if i navigate to
any tab page.
Okay, with over 30 tabs, this makes me wonder if you are loading a bunch of
bound subforms on several of these tabs. If so, you might want to look into
the idea of Tab On Demand, where you use late bound subforms that are only
populated if and when a user clicks on the tab.
The Tab On Demand technique is described in a paragraph on this page: