05-25-2012, 09:18 AM #7 VilaRestal ';drop database master;-- Join Date: Jun 2011 Location: UK Posts: I am posting the alterations here in case it may help somebody else, too: Private Sub TabControlMain_Change() Dim pgn As Access.Page Dim sbf As SubForm Dim strSubForm As String Dim VarCtlSubform Close the resources (eg record sets) which you are not really using. 2. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed this contact form

I don't know of any cases where we union queries, but it is quite common for us to have to "layer" them, i.e., create a query which is then part of Aug 27 '13 #3 reply 100+ P: 332 Mariostg @jimatqsi Just hovering the tables. Don't have any experience with an alternative myself but this would be a good place to start: http://stackoverflow.com/questions/732264/is-there-an-alternative-to-using-sun-jdbc-odbc-jdbcodbcdriver share|improve this answer answered Nov 27 '09 at 10:44 NickDK 2,587298 Advanced Search VBForums Visual Basic Database Development [RESOLVED] Cannot open any more tables If this is your first visit, be sure to check out the FAQ by clicking the link above. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-2010-error-cannot-open-any-more-tables/8362fec0-330f-42b0-899f-361343e094c1

Cannot Open Any More Tables C#

Code: Public Sub cleanup() Dim sqlstr As String Dim sqlstr2 As String Dim sqlstr3 As String Dim mynum1 As String Dim recordnum As Long ' clean up working numbers sqlstr = I saw some stuff on a google search that seemed to me to be dubious or painful advice, like basing all forms on a table instead of a query, which makes As noted, we have identified some cases where we have two forms on one tab where it would be possible and even better to use only one form. But i think that these changes will not solve your problem.

Thread Tools Rate Thread Display Modes 05-25-2012, 07:49 AM #1 corai Newly Registered User Join Date: Jun 2011 Posts: 24 Thanks: 9 Thanked 0 Times in 0 Posts VBA buit before that... JimD. 0 LVL 17 Overall: Level 17 MS Access 2 ASP.NET 2 Visual Basic Classic 2 Message Assisted Solution by:jrm213jrm2132010-08-13 Not sure if this will make any difference or if Access 2013 Cannot Open Any More Tables After adding close() statements following creation of statement objects (and calls to executeUpdate on those) as well as System.gc() statements, the error messages stopped ;-) share|improve this answer answered Oct 14

I would think each application pool would have to get it's own JET instance because the pools are isolated from one another. <http://stackoverflow.com/questions/12579186/ms-access-2010-cannot-open-any-more-databases Also, if it is the latter, I could definitely see that under any kind of load, I could probably very easily be exceeding this limit SITE WIDE, but I can't imagine

But, as previously noted, she is basically using all of the tabs on all of the open forms ... I suspect that Access keeps a "register" or buffer of some kind somewhere that is incremented every time a table is opened and vise-versa. All times are GMT -5. I have not tested it for more than read-only purposes yet.

Jet 4.0 "error : Cannot Open Any More Tables"

But for my case this solution is ok. –Christian Sep 25 '12 at 14:15 add a comment| up vote 2 down vote Often, this occurs with big/complex forms with many subforms sql excel ms-access ms-access-2010 share|improve this question asked Sep 25 '12 at 8:41 Christian 2,032930 3 Wow, 2048 tables.. Cannot Open Any More Tables C# Each such subreport/form uses data from upto 3 tables.If i open either one - report or form, it works fine.a page on microsoft's site (http://support.microsoft.com/default.aspx?scid=kb;EN-US;304536) explains what the error 'might be'. Microsoft Odbc Microsoft Access Driver Cannot Open Any More Tables How about converting an embedded macro to VB?

Roy Thompson replied Nov 1, 2009 Sorry - you may also want to read http://www.mvps.org/access/bugs/bugs0010.htm This explains the problem about number of open forms Top Best Answer 0 Mark this reply weblink Alun Davies replied Nov 1, 2009 Thomas, I love Access as a front end to SQL for prototype, but it does have limits on what it can do ( and on closing of recordsets right away). 2. Microsoft Access is a very powerful client/server development tool. Cannot Open Any More Databases

If your application is as tight as you say, then you have simply gone as far as you can with Access. Here it is. I was calling this functions in many queries for subforms and pop-up forms. navigate here If you have a lot of connections in the TIME_WAIT state, you could try forcing a garbage collection on connection closes or perhaps regular intervals.

I can get subject message to appear by hovering back and forth on the tables of a database that has about 30 tables. Each FIELD that I request counts against me!?! This form had many subforms and combos.

In short, you never can determine when you're going to hit this error until you do.

I think I should be OK with this approach, but maybe Jet 4.0 doesn't like this in some way? A Very annoying new feature. What is exactly meant by a "data set"? While there are a fair number of forms and queries involved, there is nothing like 1024 or 2048 or whatever limit applies to 2007.

But what amazes me is the fact that untill now NO patch was made for this issue. –Kico Lobo Nov 27 '09 at 12:10 add a comment| up vote 0 down It is possible that some recordsets may not be getting closed explicitly. And neither would I bet everything on 2048 being the actual limit of tables handles - the point where that error occurs. his comment is here Not that the product hit a limit, but that when it hit the limit it failed without explanation, warning, or any other sort of grace.

Delete From Working Where Results Not In (Select Results From Squares) Delete From Squares Where Results Not In (Select Results From Working) Reply With Quote Oct 22nd, 2007,01:29 PM #7 Hack