brian.naille
New member
- Local time
- Today, 13:01
- Joined
- Mar 1, 2010
- Messages
- 1
I am a newbie to this forum and am hoping any of you can help. I have a MS Access 2003 mdb which is giving me fits. The issue I am getting is that when you try to close the db, it will exit the database but NOT MS Access. You are left with an Access empty window which will not exit and has to be end tasked.
I've looked at a bunch of forums and found suggestions about objects that need to be closed before closing the db. I tried that to no avail - I wrote a function that cycles through and closes all objects (forms, modules, workspaces, databases, recordsets, etc.). The first time I tracked this error down, I finally found the problem to be with a certain global variable. Once it got assigned, the app wouldn't close. So, I wrote a work-around and voila! But, now it's back again.
I have now added a section that nullifies all of my global variables (actually they are "public" not "global") but it doesn't seem to help either.
Is there any way I can figure out what resource is hanging on and keeping Access from properly closing? I don't think you can trigger an end task from VBA but it's sure tempting since my head is getting sore from banging against my desk. ANY suggestions would be appreciated (aside from quitting my job and taking up crochet).
Thanks!
I've looked at a bunch of forums and found suggestions about objects that need to be closed before closing the db. I tried that to no avail - I wrote a function that cycles through and closes all objects (forms, modules, workspaces, databases, recordsets, etc.). The first time I tracked this error down, I finally found the problem to be with a certain global variable. Once it got assigned, the app wouldn't close. So, I wrote a work-around and voila! But, now it's back again.
I have now added a section that nullifies all of my global variables (actually they are "public" not "global") but it doesn't seem to help either.
Is there any way I can figure out what resource is hanging on and keeping Access from properly closing? I don't think you can trigger an end task from VBA but it's sure tempting since my head is getting sore from banging against my desk. ANY suggestions would be appreciated (aside from quitting my job and taking up crochet).
Thanks!