[AccessD] Error 3014 Cannot open any more tables

[Dan Waters]

Hi Janet,

Just as a test you could try setting a static database variable when you open this application.

Static dbs As DAO.Database
Dim stgBEFullPath as String

stgBEFullPath = ["FullPathToDataMDB"]
Set dbs = DBEngine(0).OpenDatabase(stgBEFullPath)

Good Luck!
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: April 25, 2017 17:55
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3014 Cannot open any more tables

Is there a registry key that can be increased like the MaxLocksPerFile hack:

https://support.microsoft.com/en-us/help/815281/-file-sharing-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

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