Cannot Open Any More Databases. Error 3048
Contents |
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to cannot open any more databases access 2010 Page... Thread Tools Rating: Display Modes 02-13-2007, 02:14 AM #1
Cannot Open Any More Databases Access 2013
Dwight Registered User Join Date: Mar 2003 Posts: 168 Thanks: 0 Thanked 0 Times in 0 Posts Error 3048: Cannot runtime error 3048 open any more databases My database sometimes produces Error 3048: Cannot open any more databases. After researching this on the Internet I now know that it is because Access has an internal limit of 255 simultaneous connections to Jet. A “connection” includes things like combo boxes, recordsets, queries, etc…..and these add up faster than one might think. I believe the culprit may be a particularly complex report my users frequently run. It is composed of several subreports and each subreport is based on several nested queries. I used nested queries a lot throughout my database. And sometimes these nested queries contain subqueries further increasing their complexity. For example, the complex report probably requires at least 30 queries to run to produce the output. My questions are: 1) Are all 30 “query connections” open while the report is open? Or are only the final queries in the nested series open? 2) I could create temp tables and append the data to the table and then pull it out with a query and base the report on this. Would this reduce the number of connections because only the queries pulling the data from the tables would be “open”? (Generally, temp tables seem to be frowned upon by the experts on this forum) Sometimes I do use recordsets and I have also gone back through to make sure that each time I open a recordset it gets closed e.g., rst.close. Thanks. Dwight View Public Profile Find More Posts by Dwight 02-13-2007, 02:41 AM #2 KenHigg Registered User Join Date: Jun 2004 Posts: 13,295 Thanks: 7 Thanked 155 Times in 129 Posts a. I'm not sure the number of queries running is producing the error, but my quess is that you're on the right track. b. Doing the temp table sounds
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just http://www.access-programmers.co.uk/forums/showthread.php?t=122973 copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Forms Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Forms Forum Runtime error '3048'cannot open anymore databases thread702-1094748 Forum Search FAQs Links MVPs Runtime error '3048'cannot open anymore databases Runtime error '3048'cannot open anymore databases ScubaStevo (Programmer) (OP) 20 Jul 05 03:41 HiI can this error message when trying to open a http://www.tek-tips.com/viewthread.cfm?qid=1094748 form many times in a loop and append records to a table. after 125 records are added, i get a pop up message saying:Runtime error '3048'cannot open anymore databaseshow can i avoid this?ThanksSteve RE: Runtime error '3048'cannot open anymore databases PHV (MIS) 20 Jul 05 16:40 Without seeing the code it's hard to say anything ... Hope This Helps, PH.Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886 RE: Runtime error '3048'cannot open anymore databases Trevil (Programmer) 20 Jul 05 16:51 About a year ago, I got involved with an application that had MANY aborts due to this error.I'll look for my notes, but the following is the general idea:1. If you open it -- then close it when not used.This applies to all recordsets, queries, etc.2. There is a limit in Access to how many tables can be opened (maybe 180? of course I don't remember).Each table takes on entry unless it's linked, then it takes two.3. If you have a few monster queries that seem to open every table, you need a better solution.We found it necessary to sometimes create a temp table with the query, then reference the temp table.We eventually
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 https://social.msdn.microsoft.com/Forums/office/en-US/b018ec1e-0927-4e0c-b797-b539296465a1/docmdoutputto-error-3048-cannot-open-any-more-databases?forum=accessdev Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: DoCmd.OutputTo - error 3048 cannot open any more databases Microsoft Office for Developers > Access for Developers Question cannot open 0 Sign in to vote Hi everyone. I do really appreciate anyone help. Ihave asplit database. Icreated simple report based on query containing only one table (containing no combo or list boxes, the report source is saved query). When Ioutput the report to pdf (or rtf) using DoCmd.OutputTo acOutputReport, "Report", acFormatPDF, "C:\Folder\Name.pdf", False it takes one database reference. When I repeat it several cannot open any times „Iget the error 3048 – Can’t open any more databases“. Icount the number of database references using the function TablesAvailable() from stackoverflow.com and this is the way I found that DoCmd.OutpuTo wastes references. Please do you have any idea why is this happening? Ihave complex database and it annoys users, when the error fires several times per day. Many thanks in advance Monday, February 02, 2015 7:32 AM Reply | Quote Answers 0 Sign in to vote Hi Tomas, Thanks for your feedback, I can reproduce your issue when keep the report object opened. # Environment: Access 2013 + Windows 8.1 # Workaround: To work around this issue, you need to close the report object before exporting the report. Sub TestAvailableTable() DoCmd.Close acReport, "Threads1 Query" For i = 1 To 300 DoCmd.OutputTo acOutputReport, "Threads1 Query", acFormatPDF, "name" & 1 & ".pdf", False Next Debug.Print "Done" End Sub As I tested, it works fine after 300 times exporting. Please let me know whether it works for you. Regards, Jeffrey We are trying to better understand customer views on social support experience, so your participation in this interview proj