[AccessD] Error 3014 Cannot open any more tables

Wed Apr 26 18:11:19 CDT 2017

Send me a copy and I'll put it up on one of my websites then post the URL here.

:)

On 26 Apr 2017 at 22:37, Dan Waters wrote:

> How would I post it?
> 
> Dan
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of jack drawbridge Sent: April 26, 2017 17:27 To: Access Developers
> discussion and problem solving Subject: Re: [AccessD] Error 3014
> Cannot open any more tables
> 
> 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
> >
> --
> 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
> 