Running Access from the Scheduler

M

mrsharkbait

Hi,

I have a VBScript that I want to run on a scheduled basis
on a Windows 2000 Server. The script contains a query to
an Access 2000 .mdb database and exporting it to XML
using the Access 2002 application. I use the AT command
to schedule the process.

When I first installed the script, it ran fine. But
after about a month, it failed. I think this coincided
with the server being upgraded to sp1, but I cannot be
sure. Now when I look at the Application Event Log, I
get this message: "Rejected Safe Mode action" from
Access. Right now everything is run with Administrator
privileges, so I don't think permissions is an issue here.

Also, both the MSACCESS.EXE and WSCRIPT.EXE processes are
left hanging and I cannot shut them down.

I have searched all over and could not find any
information about this error. Since I think this is a
routine thing (running a query on a scheduled basis) I'm
thinking I may be doing something wrong. Can anyone shed
some light into this?

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessing Exchange via Task Scheduler run on a Server 0
Running Outlook as Scheduled task 1
Running Access macro from vbscript on a non-MS Office computer 1
Find out what process has db table locked? - ACC 2K 0
Kallal's vbscript and scheduled tasks 5
Scheduling a query to run 2
Accessing Project Schedule from Top Level site 0
Printing Word Doc via Scheduled Task 2

Top