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)
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)