Hello all,
I have a report that consists of a parent, 5 children and those children have anywhere from 2 to 7 children. This was done so that all of our different reports could be printed on one page for PDF convenience reasons.
The problem. Ever since this report's conception, it has been having memory problems and font initialization error problems.
After searching I have heard mention that leaving the recordset open will cause a memory leak of sorts and cause Access to flip out. I am using DAO. Is it necessary to explicitly close all recordsets that I open or is this an ADO thing?
Anyone have any other thoughts (other than the reports are just huge) as to why I get the error "There is not enough memory to complete the operation. Please close other programs and try again."?
Thanks for any and all suggestions.
Greg
I have a report that consists of a parent, 5 children and those children have anywhere from 2 to 7 children. This was done so that all of our different reports could be printed on one page for PDF convenience reasons.
The problem. Ever since this report's conception, it has been having memory problems and font initialization error problems.
After searching I have heard mention that leaving the recordset open will cause a memory leak of sorts and cause Access to flip out. I am using DAO. Is it necessary to explicitly close all recordsets that I open or is this an ADO thing?
Anyone have any other thoughts (other than the reports are just huge) as to why I get the error "There is not enough memory to complete the operation. Please close other programs and try again."?
Thanks for any and all suggestions.
Greg