Is this only just the one query? First off, your app should have been split from the beginning if it was going to be used in a multi-user environment. Chris Ward The database is 2010 All the references are good, but I wouldn't think that that would cause the issue based on the symptoms ------- tblEquipment - no it is Chris Ward Edited by KCDW Wednesday, May 22, 2013 9:08 PM Wednesday, May 22, 2013 8:42 PM Reply | Quote 2 Sign in to vote It's not immediately obvious to me http://knowaretech.com/cannot-open/access-cannot-open-any-more-databases.html
One thing to look at, by way of "tinkering", is whether your reports/subreports use combo boxes to lookup values to be displayed. The database table for FEMA Equipment rates are somewhat kludgy. Should all the like information be used only once in a higher level? Asked another way, how many of those 30 queries are NOT lookup queries?
No always. Wait... The key is to load data only when it's being displayed. There is a record length limit however.
Especially bad in access as it all runs locally and could take a lifetime. –Matt Donnan Sep 25 '12 at 14:41 That's probably because my question was if there e) Referring to the RecordsetClone of forms (even where you do set the objects to nothing. Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! Is there a way to get both pieces of data in a single SQL in the Function?
Is it the getFEMArate() function, and my suggested improvement to it? Meyers-Jouan Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... I like the structure as it makes it very quick to make a small change in one place which is then reflected in lots of places throughout the database... http://www.access-programmers.co.uk/forums/showthread.php?t=122973 A recordsource with one table and one query will use a minimum of 4 table handles (1 for the recordsource, one for the table, one for the query, one for the
I suspect the issues is that there is an overlap in the queries which opens multiple and the same database files. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. Not sure how to condense them though. Join & Ask a Question Need Help in Real-Time?
You can have any number of tables that use a Primary Key as their Foreign Key. https://bytes.com/topic/access/answers/788117-access-2007-cannot-open-any-more-databases Michael S. Access 2013 Cannot Open Any More Databases A form's recordsource uses a table handle. Too Many Databases Open Ms Access thanks for your time!
d) Code that opens recordsets, and fails to close them and set the objects to Nothing. his comment is here 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. chris_lydon replied May 26, 2014 Hi Jim I'll look into this. thanks guys.
Squire4HireView Member Profile Dec 21 2012, 01:22 PM Post#5Posts: 921Joined: 1-October 10From: North of the 49th ParallelAgreed. Attributing the problem to splitting is a matter of the carpenter blaming his tools when the house falls down. -- David W. f) Recursive code that opens recordsets. this contact form I'd like to have a look at it to see if I can figure out what's up.
Browse other questions tagged sql excel ms-access ms-access-2010 or ask your own question. Doing the temp table sounds like a good idea. For example, when I un-split my database, no other changes made, the same form opens without error.
I am unfamiliar with the process of temporary tables. I will probably regret asking you to post the details for each query but I think it is the possibly the number and complexity of the queries that is causing the f) Recursive code that opens recordsets. I will give the temp tables a go and see what happens.
Each time you execute a linked query, you are opening the remote database. I'd like to have a look at it to see if I can figure out what's up. If your app without linked tables is that close to the table handles limit, then you're being very inefficient. http://knowaretech.com/cannot-open/access-query-error-cannot-open-database.html I'm not sure why that would have happened, but you could avoid it by not importing, as noted above.Third, that error message typically indicates a VERY heavy form with lots of
what was I going to say again? 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 Hi Suzy, When you run the and after looking through the forums, i found a suggestion to normalize my data to eliminate this error msg. Jim. 0 Message Author Comment by:cansevin2014-04-25 Ok...
Could you use something like this instead of a Left Join for this main query? So using CurrentDb, but only using it once for the lifetime of the application instance, is safer, with no practical performance penalty. but Access tables can have a LOT more than 50,000 rows. Each query is different, but the two of the subreport's queries use a common query as one of the sources.
My database has 109 separate tables. Perhaps this is due to a limit in A2003that no longer exists in A2010. Fenton "Allen Browne"
The database is split into front end and back end MDB files. If mixing Functions and Queries is oKay then would it be better to get all the Union Queries through a Function as well and just make the other queries off of Thanks again. It could be that it is just too complex and you might need to use temp tables for the Report.
PCMag Digital Group AdChoices unused Log in or Sign up PC Review Home Newsgroups > Microsoft Access > Microsoft Access VBA Modules > Cannot open any more databases and splitting databases The issue your bumping into is because your building queries on top of queries. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 2nd, 2007,07:35 PM #4 Andrew Fergus MrExcel MVP Join Date Sep 2004 Location New Zealand Posts 5,316 Hi