var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Error 3014: Cannot open any more tables
I am continually receiving "Cannot open any more tables" errors when trying to print a Report. The report is a statistics matrix encompassing many queries.
I have tried the different Jet Engine fixes, but nothing has helped.
I have tried Access 2000 and XP, with the same outcome.
Any thoughts?? Please??
If you are stacking query on query on query etc, the jet engine may loose track.
Consider to put one or two make-table query somewhere in between, in order to give the jet engine a solid recordset to continue with.
Do you mean, Create a new table with all of the record values in it and have them linked?
Could be something like:
YourReport <-> SelectQuery4 <-> SelectQuery3 <-> IntermediateTable <-> MakeIntermediateTableQuery <-> SelectQuery2 <-> SelectQuery1 <-> YourBaseTable
Hope this enlightens a bit.
Is there a way to silent the messages that ask you if you want to paste a bunch of rows into a new table?
DoCmd.Setwarnings True or False
Last edited by marion; 02-13-03 at 03:15.