Is this Access 97 I take it?
I remember having this problem for a database at a company I used to work
for. I'm trying to remember, but it seems to me that it had something to do
with no closing databases.
For example, if you did a:
Set db = currentdb()
set qdef = ....
set rs = qdef.openrecordset.....
Then if you had too many occurences of not having the qdef.close, rs.close,
db.close lines at the end of the proc, then this would cause the problem. I
hope I'm remembering correctly, but it seemed when we went through the code,
and made sure we closed out all db's, the problem went away.
"Chris" <CL*****@gmail.comwrote in message
news:11**********************@w3g2000hsg.googlegro ups.com...
>I reference a DLL that was developed in VB 6.0 in MSAccess program &
Excel add-in.
When I close my Excel add-in, Excel closes without any problem.
When I close my Access program, Access does not closes. The program
closes, but Access remains open and I need to manually end the process
of MSACCESS.EXE.
I use the statements below for declaring and using the DLL.
Public DL As New MyDLL.DLV
DL.process_data
Set DL = Nothing
I erase any arrays I use in VB, for clearing the memory. How can I
solve this problem ?
Thanks a lot in advance!