Harry Paraskeva
Registered User.
- Local time
- Today, 22:43
- Joined
- Sep 8, 2013
- Messages
- 67
Hello,
I'm coming across a strange issue that I suspect may have to do with Access 2016 limits or time-out settings that I don't see.
I have a report that is quite complex (1 report, 5 sub-reports, 1 image field feeding from images relatively linked to the report via VBA) and long, as the Print Preview spans some 1860 pages. The internal consistency of the report is good, everything displays, no issues with how things are linked, but when I try to export it to PDF or Word or any type of export really, it all runs smoothly up to page 706 to 718, when everything suddenly stops, I'm not given any specific error and the file is simply not generated. Each time I try, the page number that the process stops varies, so I suspect it has something to do with either the system running out of resources, which I don't see, as I have 32GB memory, or Access reaching some form of hard limit or time-out setting that simply cancels all actions.
I can't break the report into smaller ones, as it is about things that need to be displayed together.
The question is: Can I do anything about it? Is there a system setting, hidden Access 2016 setting, DLL or other file that needs to be tweaked to get it to export the full PDF?
I'm coming across a strange issue that I suspect may have to do with Access 2016 limits or time-out settings that I don't see.
I have a report that is quite complex (1 report, 5 sub-reports, 1 image field feeding from images relatively linked to the report via VBA) and long, as the Print Preview spans some 1860 pages. The internal consistency of the report is good, everything displays, no issues with how things are linked, but when I try to export it to PDF or Word or any type of export really, it all runs smoothly up to page 706 to 718, when everything suddenly stops, I'm not given any specific error and the file is simply not generated. Each time I try, the page number that the process stops varies, so I suspect it has something to do with either the system running out of resources, which I don't see, as I have 32GB memory, or Access reaching some form of hard limit or time-out setting that simply cancels all actions.
I can't break the report into smaller ones, as it is about things that need to be displayed together.
The question is: Can I do anything about it? Is there a system setting, hidden Access 2016 setting, DLL or other file that needs to be tweaked to get it to export the full PDF?
Last edited: