Prev: postcode finder, lookup,search
Next: Concatenating text fields with a WHERE condition
From: ctyrrell on 29 Aug 2005 08:46
I have read with interest the many discussions of the 3048 Error:
Cannot open any more databases. I understand how the number of open
Table ID's causes the problem. My question has to do with the usage of
the Elookup routine as a substitute for Dlookup. I read that Dlookup
'does not clean up after itself'. Most of the discussion centered
around the use of Dlookup in queries or in the controlsource of form
and report controls.

My question is should I also replace my uses of Dlookup in code also,
or do code references not contribute to the problem?

Interestingly enough, I am seeing the error show up at a Dlookup in the
code of a form. I could interpret this to be just that the Dlookup is
the victim, if you will, of the fact that the number of allowed table
Ids was already met, or that each time a dlookup is executed in any
code, it adds one to the number of table IDs and they never get removed
from the Table ID count. I'd really appreciate spcific information on
this, if anyone has it.

My many thanks to the veteran,knowledgable contributors to these
groups. TIA,

Christine

From: Curt on 29 Aug 2005 15:03
I'm not certain how you are leveraging the dlookup, but if you can remove it
and add the targeted table/query to your source query, that is ALWAYS a
preferred solution.

Good luck,
Curt

<ctyrrell(a)stny.rr.com> wrote in message
news:1125319579.456921.31740(a)g49g2000cwa.googlegroups.com...
>I have read with interest the many discussions of the 3048 Error:
> Cannot open any more databases. I understand how the number of open
> Table ID's causes the problem. My question has to do with the usage of
> the Elookup routine as a substitute for Dlookup. I read that Dlookup
> 'does not clean up after itself'. Most of the discussion centered
> around the use of Dlookup in queries or in the controlsource of form
> and report controls.
>
> My question is should I also replace my uses of Dlookup in code also,
> or do code references not contribute to the problem?
>
> Interestingly enough, I am seeing the error show up at a Dlookup in the
> code of a form. I could interpret this to be just that the Dlookup is
> the victim, if you will, of the fact that the number of allowed table
> Ids was already met, or that each time a dlookup is executed in any
> code, it adds one to the number of table IDs and they never get removed
> from the Table ID count. I'd really appreciate spcific information on
> this, if anyone has it.
>
> My many thanks to the veteran,knowledgable contributors to these
> groups. TIA,
>
> Christine
>


From: pietlinden on 29 Aug 2005 22:28
Are you cleaning up after yourself in your code? For example, when you
declare an object and set it, are you setting it to Nothing in your
cleanup routine? If not, find all the SETs in your code and make sure
you set all of those back to Nothing to release the memory/handles.

 | 
Pages: 1
Prev: postcode finder, lookup,search
Next: Concatenating text fields with a WHERE condition