Cannot open any more databases error?

[news2]

I'm getting the Cannot open any more databases" error. At then of use of all
databases I have opened I have set = nothing when finished with it.

Where do I look for a solution?

Dick Cleaveland

 

[aaron.kempf]

DAO is obsolete; and it has been for 10 years

seriously

if you need to SET = NOTHING then DO NOT USE THE LIBRARY!

it's simple math, kids

VB shouldn't have to SET ANYTHING = NOTHING

if you're using a _CRAP_ DAO library against my reccomendations?
then you're just plain stupid


move to ADP and ADO
it works like a charm

ACCESS DATA PROJECTS UBER ALLES

 

[news2]

DAO is obsolete; and it has been for 10 years

seriously

if you need to SET = NOTHING then DO NOT USE THE LIBRARY!

it's simple math, kids

VB shouldn't have to SET ANYTHING = NOTHING

if you're using a _CRAP_ DAO library against my reccomendations?
then you're just plain stupid


move to ADP and ADO
it works like a charm

ACCESS DATA PROJECTS UBER ALLES

Thank you for the detailed and polite response. But I'm afraid I still
don't know what to do with the information you gave me.

I've searched the archives and saw some references to using the set .. to
nothing as a solution, that's why I tried it.

There are alse feferences to closing tables and queries that are no longer
in use, but it's not clear to me how to do that (other than setting to
nothing)

Dick

 

[aaron.kempf]

a lot of people still use this crap library, called DAO

even though you've got to explicitly (verbose) code .Close and Set =
nothing for each object

it's ridiculous

move to ADO, or screw yourself with performance, an obsolete library
(DAO hasn't been included in Windows, Office or MDAC for close to 10
years) and mountains of unmaintainable code in the long run

-Aaron

 

[Joseph Meehan]

I'm getting the Cannot open any more databases" error. At then of use
of all databases I have opened I have set = nothing when finished
with it.

Where do I look for a solution?

Dick Cleaveland

Don't worry about Aaron, he has his own problems.

Is the error message an exact and full quote? How many databases are
being opened during your session? Manually or via code?

 

[aaron.kempf]

Joseph

seriously kid

if you've got to explicitly .CLOSE and SET NOTHING for _ANY_ library
you should move on

Just use ADO and you won't have to de-allocate pointers and crap

leave that kinda B$ for the C++ kids who can't get anything done on
time

This is Visual Basic.
and if the library makes you clean up after it? THEN MOVE TO A BETTER
LIBRARY

DAO is roadkill; it hasn't been included with Windows, Office or MDAC
for a decade

you're doing nothing but asking for trouble if you're still using DAO

 

[Joseph Meehan]

Joseph

seriously kid

Thank you, I have not been called a kid in over 40 years.

 

[news2]

Is the error message an exact and full quote? How many databases are
being opened during your session? Manually or via code?

-

Exact quote.

All are being opened by code.

How do I find out how many are open?

Here's the general situation:

There are many boolean variables associated with a result, with the user
being able to independently choose which ones are t/f. I want to be able to
display the status of the result upon the change of any of the variables.
Hence, for the code associated with each change option I have put in a sub
call to recompute the status, to wit:

Private Sub EDAYD_Click()
EDA = DateSerial(Year(EDA) - 1, Month(EDA), Day(EDA))
'DoCounts '<<<<<<<<<<<<<< this recomputes status.
End Sub

I have commented out a bunch of these (there are 26) and the error does not
show. But when not commented out, it seems that even before any of these
events are actuated, I get the error! There are other places where the sub
is called, but it remains these 26 that seem to be the problem. Seems nutty
to me.

If I knew how to count the open databases it would help me isolate the
problem. I have been assuming that when a form is closed the databases that
were used by that form's code are closed. Is that correct, or must I search
the entire application? Also, do other currently-active Access applications
affect this total?

Dick Cleaveland

 

[aaron.kempf]

tell me how i'm wrong dude

tell me how DAO is faster
tell me how you ENJOY using .Close and Set Nothing on every single
object you do

I say-- that it is unnecessary verbosity

use friggin ADO and STFU and spit on anyone still using DAO

DAO hasn't been included with Office, Windows or MDAC for a decade

 

[aaron.kempf]

count the open databases?

are you friggin kidding me?

it's a bug in DAO, stfu and move away from DAO