Exit Database?

[jasonphillipstx]

I call a macro from and access mdb file form a batch file. The macro runs various code that emails reports to my people. I want the program to automatically exit when done and close access. However, every method I have tried from the macro and vba returns an error. Can I do this successfully?

I thanks you in advance for your help.

 

[hneal98]

Access Macros has a command called Quit that exits Access.

 

[jasonphillipstx]

That command give me an automation error saying that is cannot exit access right now.

 

[hneal98]

You have to make sure all other processes are finished before calling it. Also, make sure any forms, or reports that might have been opened are now closed. Other than that, not sure what is happening. If you still have problems, perhaps someone else will be able to come up with a solution.