I have a pretty complex (for me!!) Access database, with lots of queries/forms/reports and links to tables both in a back-end and to Excel files. Because I hotdesk across three sites and also work from home sometimes, I have the front-end, back-end and linked files all in different folders on a high capacity flash-drive (regularly backed up!)
I got a new laptop recently and almost everything works perfectly, but there’s one part that causes it to crash every time. This is a section that cycles through 30 options in a listbox, runs various make-table queries, then runs a long report for each option, made of many sub-reports and outputs it as a PDF with a filename based on the current entry in the listbox. Then it moves onto the next option and repeats.
It works perfectly on three other PCs. It even works on my old laptop, which I need to get rid of, because of different problems.
All the other parts of my database work fine on my new laptop, but this one section, on this new laptop, crashes it every single time. I had used DoCmd.SetWarnings False. I set that back to True and when the database crashed next time it said “System Resource Exceeded”.
The weird thing is that there another very similar module in the same database, building reports from entries in a different listbox and also outputting as PDFs and that one does not crash it.
It really does seem to be machine-specific, so what settings should I be looking at on this new laptop?
I got a new laptop recently and almost everything works perfectly, but there’s one part that causes it to crash every time. This is a section that cycles through 30 options in a listbox, runs various make-table queries, then runs a long report for each option, made of many sub-reports and outputs it as a PDF with a filename based on the current entry in the listbox. Then it moves onto the next option and repeats.
It works perfectly on three other PCs. It even works on my old laptop, which I need to get rid of, because of different problems.
All the other parts of my database work fine on my new laptop, but this one section, on this new laptop, crashes it every single time. I had used DoCmd.SetWarnings False. I set that back to True and when the database crashed next time it said “System Resource Exceeded”.
The weird thing is that there another very similar module in the same database, building reports from entries in a different listbox and also outputting as PDFs and that one does not crash it.
It really does seem to be machine-specific, so what settings should I be looking at on this new laptop?