Can't exit Access after running a function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DaveAmann - 03 May 2005 13:11 GMT

I intermittantly get an error message after running a VBA function that has
DoCmd.Quit acSave at the end. The message states that I can't exit access
now becasue there is a VB session open. From all my checks, I have closed
all objects and set recordsets/dbs to nothing. Is there another command that
will close Access properly at the completion of the function. I start this
function via a macro called by the Windows Task Scheduler

Signature

Dave

Reply to this Message

Andy - 03 May 2005 21:47 GMT

You might try Application.quit

hth,
Andy

> I intermittantly get an error message after running a VBA function that has
> DoCmd.Quit acSave at the end. The message states that I can't exit access
> now becasue there is a VB session open. From all my checks, I have closed
> all objects and set recordsets/dbs to nothing. Is there another command that
> will close Access properly at the completion of the function. I start this
> function via a macro called by the Windows Task Scheduler

Reply to this Message