'Need VBScript help to close Access database and shell

I have an Access database that is open that is preventing a scheduled WinZip job from executing every night (all via Task Scheduler). I inherited the script and am new to VBScript. I've tried the following commands but have had no luck yet:

appAccess.CloseCurrentDatabase
appAccess.Application.Quit
Access.Quit (Object Required: 'Access" runtime error)
DoCmd.Quit acQuitSaveAll (Object Required: 'DoCmd" runtime error

Here's the script I inherited/modified:

Dim appAccess 
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("C:\Users\winshut\Desktop\SAP Winshuttle Extracts\SAP Data Extract 2.ACCDB")

Seems simple I'm just missing something. Thanks in advance

vbscript


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions