Cannot Open Any More Databases Error
Contents |
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins
Access 2013 Cannot Open Any More Databases
Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick cannot open any more databases access 2007 access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: cannot open any more databases Microsoft Office error 3048 cannot open any more databases for Developers > Access for Developers Question 0 Sign in to vote I have an application that I'm working on. It is split, both front and back are in the same folder on my local drive. It is
Cannot Open Any More Tables
in development still, so no one else is accessing it. I am working on a report that has three subreports. All of the data comes from the same backend. Each subreport and the main report have queries as their data source. Each query is different, but the two of the subreport's queries use a common query as one of the sources. When I try to preview the report, I get the message that is in a
Access Temp Tables
loop which says that I cannot open any more databases. There are only two databases open - the front-end and the back-end. For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ "We came all this way to explore the Moon, and the most important thing is that we discovered the Earth." - Bill Anders, Apollo 8. Wednesday, May 22, 2013 4:53 PM Reply | Quote Answers 0 Sign in to vote I sent you an email with the zipped folder attached. thank you for taking time to look at it.. I have sent you a database with a revised version of the report that uses no subreports, which works in both Report View and Print Preview. Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html Marked as answer by -suzyQ Friday, May 31, 2013 5:12 PM Friday, May 31, 2013 4:55 PM Reply | Quote All replies 0 Sign in to vote Hi Suzy, When you run the underlying Query's one at time do you get the same error? It could be that it is just too complex and you might need to use temp tables for the Report. Chris Ward Edited by KCDW Wednesday, May 22, 2013 6:21 PM Wednesday, May 22, 2013 6:18 PM Reply | Quote 0 Sign in to vote
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Help in troubleshooting "Cannot open any more databases" (Error 3048) Want to Advertise Here? Solved Help in troubleshooting "Cannot open any more databases" (Error 3048) Posted on https://social.msdn.microsoft.com/Forums/office/en-US/9993d229-8a00-4a59-a796-dfa2dad505bc/cannot-open-any-more-databases?forum=accessdev 2010-11-19 MS Access Databases 3 Verified Solutions 22 Comments 3,400 Views Last Modified: 2012-05-10 Hello, I have Access 2003 app which uses multilevel tab controls. I am running into the Jet db engine limit of 2048 handles to open tables. I am trying to optimize and reduce the number of active connections and would like to determine the current number of "handles" https://www.experts-exchange.com/questions/26628233/Help-in-troubleshooting-Cannot-open-any-more-databases-Error-3048.html being used. Can the current index of the TableID or count be determined and reported at runtime? Thanks, Craig Harrington 0 Question by:cnharrington Facebook Twitter LinkedIn Google LVL 74 Best Solution byJeffrey Coachman To me it just looks like your form has too many Objects on it. (is too complex) Remember that objects like nested subfoms, and tab controls "Weigh" a lot. From here: http://www22.brinkster.com/accessory/wip.shtml Go to Solution 22 Comments LVL 75 Overall: Level 75 MS Access 75 Databases 13 Message Active today Expert Comment by:DatabaseMX (Joe Anderson - Access MVP)2010-11-19 Active connections? Handles? Index of TableID ? Not quite following ? mx 0 Message Author Comment by:cnharrington2010-11-19 I am trying to find a way to monitor the conditions that cause Access to generate Error #3048 "Too many databsaes open". The explanation thatfollows was copied from http://database.itags.org/ms-access-database/3406/ Thanks, Craig Error #3048 is usually caused by your database application trying to handle too many tables at the same time. There are 2048 "table handles," or TableID's, available for Jet 3.51 and 4.0 (1024 TableID's for Jet 3.0 and 3.5) that Access requires when dealing
Post your question and get tips & solutions from a community of 418,469 IT Pros & Developers. It's quick & easy. Cannot open any more databases. P: n/a ultraton While trying to https://bytes.com/topic/access/answers/208627-cannot-open-any-more-databases print a report from Access the user receives the following error: Cannot open any more databases. Okay Help Does anyone have any ideas about this behavior? Thank you very much. Nov 13 '05 #1 Post Reply Share this Question 6 Replies P: n/a Allen Browne The message means that Access is trying to open too many connections to the database. Access sets aside memory space for 2048 database connections. The kinds of cannot open things that use database connections include: a) Forms and reports (including subforms and subreports): close any you don't need. b) Forms/reports that contains lots of list/combo boxes across the record. c) Forms/reports/queries that use the domain aggergate functions, such as DLookup(), DMax(). d) Code that opens recordsets, and fails to close them and set the objects to Nothing. e) Referring to the RecordsetClone of forms (even where you do set the objects to cannot open any nothing. f) Recursive code that opens recordsets. b, c, and d are the most common culprits. BTW, if you are using the original Access 97, only 1024 database connections were available, so you need to apply SR2. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "ultraton"
- wrote in message news:11**********************@f14g2000cwb.googlegr oups.com... While trying to print a report from Access the user receives the following error: Cannot open any more databases. Okay Help Does anyone have any ideas about this behavior? Thank you very much. Nov 13 '05 #2 P: n/a ultraton Thank you, Allen. I believe that (b) and/or (c) are the problem. How should it proceed to fix it? I am using Access2000. Nov 13 '05 #3 P: n/a Allen Browne For (b), redesign the table. If you have lots of repeating fields, create another table that contains many records related to the first one instead. For (c), you may be able to use a subquery, or perhaps a replacement for DLookup() that cleans up after itself. There's one here: http://allenbrowne.com/ser-42.html Or you may be able to move the DLookup() into the Control Source of the text box on the form, so it is not calculated f