straigh thing when run access on scheduler

  • Thread starter Thread starter Piotr Maciejewski
  • Start date Start date
P

Piotr Maciejewski

I create small SQL database and Access project.
This project have form with subform. On start form is open, subform is fill
with data from SQL Server.
Next I add runinng this Access project from Scheduled Task (on my account)
When
- run program from my acount everything is OK.
- run program by Scheduled Task WHEN I AM LOGIN IN - everything is OK
- run program by Scheduled Task WHEN NOONE IS LOGIN IN - there are errors.

I check this error a lot of time.
Problem is then on last situation:
Forms!Form1.subform!Form
is empty! (normaly is not empty) ('Form1' is name of form, 'subform' is name
of subform on this form)

Is anyone on net who know any sollution to this problem?
Why Access doesn't create subform when there is no user logged on machine
(Windows 2003)?
Can command 'AT /interactive' help?

Peter Maciejewski
www.gbbsoft.pl
 
Piotr,

When noone is logged in, what security context is the scheduled task going
to run in? - and does that security credential have the authorization to
access network resources, SQL server, etc.,. ?
 
On Scheduler Task I enter my user name and my password. Program works on my
security context - I'm sure, because I check it on SQL Server log!
There is no problem with connection with SQL Server but with creating
subform. Subrorm isn't created - nor subform OnLoad event raises! I don't
know why...
 
Back
Top