Elookup vs Dlookup, Error 3048

[ctyrrell]

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,knowled gable contributors to these
groups. TIA,

Christine

[Curt]

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

<ct******@stny. rr.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.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,knowled gable contributors to these
groups. TIA,

Christine

[pietlinden]

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.