[AccessD] Can't open any more databases

Thanks for your advice and feedback Susan. 
I'm running on Win 2000 server, not Novell. I am satisfied that I am overstressing the Jet engine because of the number of forms, queries and other things that I have open at the same time. I have tried the 'Just in Time' method of reducing the number of open table references, but it was very slow. I will let you know how I solved it properly, if I ever do. The MVPS <http://www.mvps.org/access/bugs/bugs0010.htm>  site had an interesting article which explained the problem, but Jet 3.6 didn't seem to solve it.

Cheers 
David Ô¿Ô¬ 
Brisbane
Australia 

Your message was :
Date: Wed, 1 Oct 2003 18:38:19 -0400
From: "Susan Harkins" <ssharkins at bellsouth.net>
Subject: Re: [AccessD] Can't open any more databases
To: "Access Developers discussion and problem solving"
	<accessd at databaseadvisors.com>
Message-ID: <003701c3886c$b75bfb50$220110ac at SUSANONE>
Content-Type: text/plain; charset="iso-8859-1"

Can't open any more databases. The one time I ran into this, I ended up redoing my form to get rid of the subforms -- never did find the culprit. I was told it could be resolved with a simple switch on the Novell server (which did seem to be the culprit) -- but IT refused. 

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