[AccessD] Can't open any more databases

RE: [AccessD] Can't open any more databases...something wrong there David ...I use JIT to speed up a db, not slow it down :(((

William Hindman
<http://www.freestateproject.org> - Do you want liberty in your lifetime?


  ----- Original Message ----- 
  From: David Fenton 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, October 02, 2003 6:17 PM
  Subject: RE: [AccessD] Can't open any more databases


  Thanks for your feedback and advice John. The MVPS article (although referring to ACC97) indirectly led me to believe that Jet 3.6 allowed 2048 references since the old Jet allowed 1024. Given what you have mentioned, I would be most definitely over the 128 limit then. I have tried the 'Just in time' method and have found it to be painfully slow. The user clicks on a tab and has to wait for the records to be filtered into the subform. I put the recordsource SQL string in a Case statement linked to the tab control. Perhaps I need to review the filtering or something.


  Cheers
  David Ô¿Ô¬
  Brisbane

  Australia 


  Your message was:

  Date: Wed, 1 Oct 2003 19:30:02 -0400

  From: "John Colby" <jcolby at colbyconsulting.com>

  Subject: RE: [AccessD] Can't open any more databases

  To: "Access Developers discussion and problem solving"

          <accessd at databaseadvisors.com>

  Message-ID: <DCEFJAOENMNENLAAOFGPMEDBFDAA.jcolby at colbyconsulting.com>

  Content-Type: text/plain; charset="iso-8859-1"

  Can't open any more databasesIn fact the number is no where near that, at least for a2K.  Something like 128.  This includes ALL queries (combos, lists, recordsets, forms, subforms, reports etc) open at one time.  I ran into this in a very complex form when they had several other forms open.

  One thing I'd suggest if it works for you is "Just in time" subforms on the tabs.  The idea is to load the subforms on tabs as they are clicked on and unload them as the next tab is clicked on. John W. Colby www.colbyconsulting.com





------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031002/bb078148/attachment-0001.html>