David Fenton
dfe at nudgeeinternational.com
Thu Oct 2 17:33:50 CDT 2003
Thank you for your excellent insights Jim, Looks like it's back to the drawing board. I'm definitely pushing the limits of the table references then. What do you make of the MVPS <http://www.mvps.org/access/bugs/bugs0010.htm> article the, where they refer to 1024 references? When I noticed that Susan was referring to a specific problem that occurs on Novell, I knew that since I'm on Win2000 server it wouldn't help. I have temporarily solved the problem by closing other forms that happened to be open at the same time, thereby closing some references. I will experiment with refining the record source under the open subforms on the offending form. But since I can never predict what forms the user might have open, I'd prefer to work towards a more robust solution so that I can be 100% certain the user will never see the error message. Anyway, thanks for your valued help. Cheers David Fenton Ô¿Ô¬ Brisbane Australia Your message was: Date: Thu, 2 Oct 2003 06:45:54 -0400 From: "Jim Dettman" <jimdettman at earthlink.net> Subject: RE: [AccessD] Can't open any more databases To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <NEBBKADGELICHEJJCKGKEECMHIAA.jimdettman at earthlink.net> Content-Type: text/plain; charset="iso-8859-1" Can't open any more databases David, <<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 hard-coded 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031003/5b1c32e2/attachment.html>