Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    24

    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??

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    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.

    hth

  3. #3
    Join Date
    Jan 2003
    Posts
    24
    Do you mean, Create a new table with all of the record values in it and have them linked?

  4. #4
    Join Date
    Apr 2002
    Posts
    139
    Could be something like:

    YourReport <-> SelectQuery4 <-> SelectQuery3 <-> IntermediateTable <-> MakeIntermediateTableQuery <-> SelectQuery2 <-> SelectQuery1 <-> YourBaseTable

    Hope this enlightens a bit.

  5. #5
    Join Date
    Jan 2003
    Posts
    24
    Is there a way to silent the messages that ask you if you want to paste a bunch of rows into a new table?

  6. #6
    Join Date
    Apr 2002
    Posts
    139
    DoCmd.Setwarnings True or False
    Last edited by marion; 02-13-03 at 04:15.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •