Close Access Thru Scheduler 1

[rcaesar]

Hi,

I use the Hal scheduler to compact and run some macros.

How would I use the scheduler (or the Windows scheduler) to close Access completely.

I tried using Application.Quit acQuitSaveAll in the scheduler, but it just doesn't do anything (no errors, and doesn't close it).

Is there a macro (or code) I can use thru the scheduler to close.

If I have use Shell, could someone give me some clues as to how to set it up - I have little experience with it.

You guys have always come thru, and any help will be appreciated.

Thanks

 

[VBslammer]

You can run a script from the task scheduler using a .vbs file (VBScript) if you have permissions. Create the script using Notepad and name it "CloseAcess.vbs", then assign the file to your task using the task scheduler, and enter a username and password to allow it to run. The script would look something like this:

Const acQuitSaveAll = 1

On Error Resume Next

Set acc = GetObject("C:\Databases\TekTips.mdb")

If Err.Number = 0 Then
   acc.DoCmd.Quit acQuitSaveAll
End If

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[rcaesar]

Hi VBSlammer,

That was really great. I just tested it out, and it works like a charm.

Thanks a lot for your help and you deserve a star, the reason being, I have more or less searched this and other sites, and many have offered solutions, but this was the most straight forward, and extremely simple to use.

 

[mp9]

If you're usign HAL to run macros in a db, just finish the macro with a Quit action. This will close Access when the macro has finished running, with no need for separate scripts.

http://www22.brinkster.com/accessory/

 

[rcaesar]

Thanks mp9 for all the help.