[AccessD] Error 3014 Cannot open any more tables

[jack drawbridge]

Dan,

You may want to post it. There may be others with a need.

jack

On Wed, Apr 26, 2017 at 5:58 PM, Dan Waters <df.waters at outlook.com> wrote:

> I'll send a copy in the next day or so ...
>
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Kaup, Chester
> Sent: April 26, 2017 16:31
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Error 3014 Cannot open any more tables
>
> How would I get a copy of this "tool"?
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Janet Erbach
> Sent: Wednesday, April 26, 2017 4:26 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Error 3014 Cannot open any more tables
>
> [This email message was received from the Internet and came from outside
> of Kinder Morgan]
>
>
> You BET it's great!  I've used your tool countless times in the last 3
> years and it's bailed me out of some serious issues 90% of the time!  :)
> Thank you very much for making that available.
>
> On Wed, Apr 26, 2017 at 4:18 PM, Dan Waters <df.waters at outlook.com> wrote:
>
> > The DeCorrupter tool?
> >
> > Oooooohhh - now I remember.  Great!
> >
> > Dan
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Janet Erbach
> > Sent: April 26, 2017 16:12
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Error 3014 Cannot open any more tables
> >
> > I cleaned up some open recordsets in the code - I was *not* as clean
> > in my code as I thought I was.  This alone did not correct the issue,
> > though - 30 minutes after launch it hit the 3014 error again.
> >
> > BUT:  I then ran the front end through  Dan Waters' Decorrupter tool,
> > and it ran for over 3 hours without a hitch.  I closed it so that I
> > could upload it to the network and deploy it;  she's running again and
> > I will let 'er run overnight.  We'll see if she's still going come
> morning.
> >
> > Janet
> >
> > On Wed, Apr 26, 2017 at 3:24 PM, John Colby <jwcolby at gmail.com> wrote:
> >
> > > It turns out that any form and any object like a list or combo on
> > > the form also opens a recordset.  Thus this exact problem can be
> > > caused by overly complex forms.  However she expressly says it is a
> > > single "simple" form so that is probably not the issue.  File
> > > sharing locks have nothing to do with the recordsets in a FE
> > > however.  Those locks
> > control access to the BE.
> > >
> > >
> > > On 4/25/2017 6:55 PM, Rocky Smolin wrote:
> > >
> > >> Is there a registry key that can be increased like the
> > >> MaxLocksPerFile
> > >> hack:
> > >>
> > >> https://support.microsoft.com/en-us/help/815281/-file-sharin
> > >> g-lock-count-exc
> > >> eeded-error-message-during-large-transaction-processing
> > >>
> > >> http://tinyurl.com/l77zk7f
> > >>
> > >> to allow more tables?  Although John's probably right - you
> > >> probably don't need that many tables open.
> > >>
> > >> Can you trap that error and run a few lines of code which would
> > >> list all the open tables? Maybe you could spot the culprit?
> > >>
> > >> R
> > >>
> > >> -----Original Message-----
> > >> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > >> Behalf Of Janet Erbach
> > >> Sent: Tuesday, April 25, 2017 2:39 PM
> > >> To: Database Advisors
> > >> Subject: [AccessD] Error 3014 Cannot open any more tables
> > >>
> > >> 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
> > >>
> > >>
> > > --
> > > John W. Colby
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>