Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... All product names are trademarks of their respective companies. Friday, May 24, 2013 10:21 PM Reply | Quote 0 Sign in to vote Is it possible for you either to post this database where I can download it, or else You would essentially dump the data from your bottom-layer queries into a table, and then just build a report based on that table. http://ecoflashapps.com/cannot-open/cannot-open-bayes-databases.html
He says Access2000 and newer have higher ceilings before this limitaion is reached! The base data was 25 MILLION rows per year. Fenton"
It turns out I did have an "infinite loop" in my code that was opening a connection over and over again until it bummed out with the error - I was If you exceed that limit, you get the "cannot open any more databases" error. And each subreport is an open connection.In most cases, no, that's not true.
The same goes for the use of qryUnionProjects when getting data from tblInvoices.ProjectToCharge from the union query of qryCostAccountingCandM_MaterialOnTimeCards and qryCostAccountingCandM_InvoiceItems which it seems I neglected to post. You mention specific query. Well, my understanding of the way Access works is that it doesn't create multiple connections to the back end except if you tell it to. It only occurs in "Report" mode.
I can't blame the poor thing from being overwhelmed. Cannot Open Any More Databases Access 2007 That makes much more sense than not being able to open multiple databases. thank you for taking time to look at it.For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ http://www.access-programmers.co.uk/forums/showthread.php?t=280959 Cannot open any more tables Thomas Mercer-Hursh asked Oct 30, 2009 | Replies (31) We are getting this error once or twice a day now.
Please don't post that address here in the forum. I welcome all your suggestions! Some of the subreports include Excel charts in unbound object frames. PCMag Digital Group AdChoices unused Developer Forum Board index Office Access split mdb error 3048 cannot open any more databases: adp a solutio split mdb error 3048 cannot open any more
It is in development still, so no one else is accessing it. https://bytes.com/topic/access/answers/192670-cannot-open-any-more-databases-strategy-needed Post your question and get tips & solutions from a community of 418,766 IT Pros & Developers. Error 3048 Cannot Open Any More Databases It is possible that > some recordsets may not be getting closed explicitly. Too Many Databases Open Ms Access When I add 3 additional subreports, I get the error message that Access can't open any more databases.
However there is so much data that I don't want to have to add a big data conversion job as well into the mix. http://ecoflashapps.com/cannot-open/cannot-open-bayes-databases-r-w-lock-failed.html Thanks roughly akin to what the situation is. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no I didn't spend time trying to see if the function could be eliminated in favor of direct SQL.Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html Friday, May 31, 2013 8:04 PM The other thing that may lie at the heart of the problem is if you have not properly normalized your data.
Got that. Meyers-Jouan Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Some of the subreports include Excel charts in unbound object frames. navigate here It doesn't necessarily have anything to do with what it claims. -- David W.
Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... You'll have to be more explicit. 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
Thursday, May 23, 2013 4:36 PM Reply | Quote 0 Sign in to vote Hi Dirk, This is kind of an aside, but I'm not sure what the difference is in Thanks roughly akin to what the situation is. Having so much (nested) queries was/is really the only solution I can think of to create my beloved 'scoreboard' form. Fenton"
This is extremely interesting. I was calling this functions in many queries for subforms and pop-up forms. MS ACCESS is made for small data. his comment is here If you remember to explicitly close each database that you open before you let your form go away, this problem should radically improve. __________________ I'm a certified grandpa and proud of
Maybe you exceeded one of those. How to make figure bigger in subfigures when width? Requeries impact the number of references. 2.