By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,586 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,586 IT Pros & Developers. It's quick & easy.

Getting 3014 errors trying to run list of reports

100+
P: 167
I have a form that allows the users to select/highlight reports in a list that they want to preview/print. There are about 30 reports and when they only select a few it works fine. However, if they select all the reports to preview, then about 1/2 way through it gives a 3014 error (can not open any more tables). The reports all have queries in which some build temp tables. Is there any way I can run some statement part way through to close some of them and then continue to run the rest of the reports?
May 7 '08 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
I have a form that allows the users to select/highlight reports in a list that they want to preview/print. There are about 30 reports and when they only select a few it works fine. However, if they select all the reports to preview, then about 1/2 way through it gives a 3014 error (can not open any more tables). The reports all have queries in which some build temp tables. Is there any way I can run some statement part way through to close some of them and then continue to run the rest of the reports?
Hmm, I'm afraid that closing reports automatically can look odd to the user and what criteria is to be used.

Perhaps better to group the reports in logical groups and let them first select such a group before allowing them to make a selection of multiple reports.
Another option is to limit the number of reports they can select to the max before this 3014 error is triggered, as there's no way (other than combining reports into one) to prevent Access from hitting the limit...

Not much, but there's no real way to workaround an internal max open tables.

Nic;o)
May 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.