Running a query / macro through scheduled task

[tez]

Hi everyone,

I have a MS Access append query that updates a table from a linked Excel spreadsheet.
Im trying to automate the running of the query during the night.



Ive tried a couple of ways to schedule the task with Windows Task Scheduler, although each time, it appears to start the job, but then just hang (task never completes, doesnt run the query or macro and when I log back into Windows, the msaccess.exe process is running).

Methods Ive used are:

- command line with /x macroname

- vbs script which runs the query / macro

'Read from a Microsoft ACCESS database

Option Explicit

dim oaccess

'execute another Access macro
set oaccess = createobject("access.application")
oaccess.opencurrentdatabase "H:\Database.mdb"
oaccess.docmd.setwarnings false
oaccess.DoCmd.RunMacro "Macro1"
oaccess.docmd.setwarnings true
oaccess.closecurrentdatabase
oaccess.quit
set oaccess=nothing

WScript.Quit(0)

- .bat file which just has the command line in it.

They all run fine when I am logged in, although it seems to hang when I am logged off the network.
I have the correct permissions as Ive scheduled a Excel macro to run and its fine.

Any ideas? Thanks

[help_me_with_access]

could it possibly be the fact that the acc file is linked to an xl b/e? i wonder if that might be the problem. not sure why it would be though...

[tez]

Not sure, I can schedule a Excel Macro fine, just not a Access one

[help_me_with_access]

what method you using for excel?

[tez]

For excel, im running a vb script to call on a macro in the spreadsheet. This works fine.

For access I tried calling a macro through vb script and it just stalled. Same with using the command line /x macroname.