Access Will Not Start via Scheduler

[Mike Thomas]

We have an Access 2000 app which is supposed to run every morning via the
Windows scheduler using the following command:

"c:\Program Files\Microsoft Office\Office\msaccess.exe"
"d:\FolderName\TheApplication.mdb" /x StartLoad

Where Start Load is a macro which simply calls a procedure, which in turn
call several other procedures, then finishes with the "Quit" command.

The problem is that it appears that when the system administrator is not
logged on Access is either not starting at all, or it is starting and
immediately hanging up - it's first task is to write a text file saying that
it has started, and this text file is not showing up.

These are the specifics:

The app is running on NT 2000 running Citrix.

When the system administrator is logged onto the server, the scheduler opens
Access, it runs, and everything is fine, so we think the above command is OK
and the program itself is executing without errors.

When he runs the above command from the Run window, everything works fine.

When he is not logged on, we have the problem described above and hours
later the scheduler thinks Access is still running.

He is at a loss and so am I. Does anyone have any idea why Access is either
not opening, or is opening and immediately stopping when the system
administrator is not logged in.

Many thanks

Mike Thomas

 

[gandalf]

Have you filled in the user?
Checked the security tab?

 

[Ray Delevaux]

Dear gandalf,

I happen to have the same problem as Mike, and I would be very pleased to have found someone who has a solution for this problem. However, your answers are in fact questions, and may do nothing to help myself and Mike sort out this problem.

Fill in the user? What? Where? How? Really, I think you need to be a bit more explicit here.

Checked the security tab? Which security tab? Where? Check for what?

I do think I have an idea what you mean, so let me answer back like this:
Yes.
Yes.

It still doesn't work. What now gandalf?

Anybody else out there who is not only knowledgeable but a good communicator too?

BTW this works fine in windows XP prof., I have the problem on a win 2k server.

Regards,

Ray Delevaux