[AccessD] Error 3014 Cannot open any more tables

[Bill Benson]

The fact that you are doing something on a timer sounds to me that this is
acting like a loop. Do you need the timer to occur as frequently as it is?
If you changed it to a larger timer interval does the runtime duration
improve? If you shrink the interval does it deteriorate? That would be your
clue.

>From my non-flammable Note 3,
Bill Benson

On Apr 25, 2017 5:40 PM, "Janet Erbach" <jerbach.db at gmail.com> wrote:

Hello, all.

I deployed a 2007 app today that is supposed to be up and running all the
time.  It's relatively simple - one form bound to a temporary table that is
emptied and refilled every minute on the form timer event.

After about 30 minutes, the app throws a 3014 Error - cannot open any more
tables.

We are running jet 4.0, which is the most current, yes?  If this is truly a
jet related error, there are a couple of things I can do to help optimize
the app - about half the queries in the app are run from saved query defs,
and I can convert all those to sql statements.  I've decompiled and
reinstalled the access database engine, both suggestions that turned up in
a google search.  But beyond these troubleshooting steps, I don't know what
else to do.

Can you please give me some clues on what may be triggering this?  I
haven't seen this error before (that I can remember, anyway) and I have
another app deployed on the shop floor which runs 24/7 and refreshes every
minute without any issues.  Any help is greatly appreciated!

Janet Erbach
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com