Scheduled task problem

B

Bill Manville

Hi

On WinXP-Pro I have set up a scheduled task to run a procedure within
an Access 2002 database. The procedure runs some queries and then
invokes Excel through automation and runs a macro in an Excel workbook.

The task is intended to be run late on Friday night when the user is
not logged in (or at least the user has been logged in and timed out to
the Ctrl+Alt+Del and enter password to continue message).
At that time, the Access procedure runs fine and Excel loads the
workbook but then there is a message "Insufficient resources to display
completely".

Running the task when the user is logged in works fine.

Is there some difference in resources made available to a task between
the cases of a user logged in and a user not logged in? Any
suggestions on how to get my task to run successfully at the intended
time?

Thanks

Bill Manville
(MVP - Microsoft Excel, Oxford, England)
 
T

Tin

make sure the account has logon as batch job and service job in local
security policy.

Tin,
n0bOdy
 
B

Bill Manville

Tin said:
make sure the account has logon as batch job and service job in local
security policy.

Sorry Tin, that's a bit too cryptic for me, a humble user.
How would I do that?
(The scheduled Access task is set to log in with the identity of the
normal user of the machine concerned).

Bill Manville
MVP - Microsoft Excel, Oxford, England
 

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

Top