Jim Dettman
jimdettman at earthlink.net
Thu Oct 2 05:45:54 CDT 2003
Can't open any more databasesDavid, <<I believe that at most I have about 60-80 table references open at any instant (knowing that it’s a split database let’s double that to 160 references). Even if I am conservative and say I have caused 500 table references and double that to 1000, it is still nowhere near the limit of 2048. I believe it is a hardcoded limit of Jet 3.6. Am I barking up the wrong tree completely?>> Yes but "table references" is probably not what you think it is. Not only does it mean every open table, but it also applies to every field reference (which is in of itself a table reference). It can add up a lot quicker then you think, especially with multiple subforms. <<It’s a split database. I have a form (Form A) open which contains a tab control with a form and subform on at least each of the ten tabs. Clicking on a button on one of these tabs, hides this main form (Form A - with all of it’s open forms etc) and opens another form (Form B) with a tab control and a bunch of forms. Each tab (seven tabs).>> From what you describe, it certainly sounds like you are bumping into the limit. And yes, the bad news is that the limit is internal to Access and cannot be modified. Your only choice is to reduce the complexity of what's going on. The other then that Susan mentioned is in regards to locks. It is possible that you are running out of locks and therefore cannot open another database because you can't place a user lock. This applies only to Novell environments. To test this out, place both the FE and BE on the same station and try the operation again. If the error still occurs, then it's not related to locking. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Fenton Sent: Wednesday, October 01, 2003 6:30 PM To: accessd at databaseadvisors.com Subject: [AccessD] Can't open any more databases I have a ACC2002 db that opens many forms and queries etc. I don’t believe I am anywhere near the 2048 max table references. It’s a split database. I have a form (Form A) open which contains a tab control with a form and subform on at least each of the ten tabs. Clicking on a button on one of these tabs, hides this main form (Form A - with all of it’s open forms etc) and opens another form (Form B) with a tab control and a bunch of forms. Each tab (seven tabs). I can happily click on a couple of the tabs and everything is fine. As soon as I click on one of the last tabs which contain 3 subforms I get the dreaded “Can’t open any more databases” message. I have read a lot of posts on this (incl. www.mvps.org/access/bugs/bugs0010.htm) and have thoroughly checked my code to ensure that all my recordset objects are closed after use. I temporarily rectified it by closing the calling form (Form A) instead of hiding it, thus closing some of the table references. Form B works perfectly now. I only get the error if too many forms are open which have obviously opened too many table references. The drawback is that it is slow to open Form B because it is closing Form A and when I close Form B, I have to wait for it to re-open Form A again and filter to the record the user was working on before they clicked the button to take then to Form B. My question: Is there anything else that I could do that I may not have considered? I believe that at most I have about 60-80 table references open at any instant (knowing that it’s a split database let’s double that to 160 references). Even if I am conservative and say I have caused 500 table references and double that to 1000, it is still nowhere near the limit of 2048. I believe it is a hardcoded limit of Jet 3.6. Am I barking up the wrong tree completely? Cheers in advance for any assistance or advice. David Ô¿Ô¬ Brisbane Australia -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031002/c374683a/attachment-0001.html>