[AccessD] Can't open any more databases

RE: [AccessD] Can't open any more databasesDavid,

  The table reference limit is 2048 for JET 3.6 and up.  See my earlier
post.

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: Thursday, October 02, 2003 6:18 PM
  To: accessd at databaseadvisors.com
  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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031003/3e61be97/attachment-0001.html>