Access/Project/Server problem

Access03
Project03 Standard
Server03 Standard Edition SP1

I have a process in which Access exports data to Project, opens an mpp
file, and creates Gantt charts. This process has been running in
various forms for years on workstations with no problem.

I have created a standalone version to run unattended as a scheduled
task on a server.

The problem:

1. App runs correctly when launched manually.
2. App runs correctly when launched as scheduled task with user still
logged on.
3. App runs correctly when launched as scheduled task before midnight
with user logged off.
4. App fails when lauched as scheduled task after midnight with user
logged off.

The error (same in all cases): Each time Access instructs Project to
open an mpp file -- "#1004: Project cannot open the file." File
permissions are set to full control for all categories of users.

There is nothing in the application or security logs that give a clue
as to what might be going on.

We haven't been able to figure out what happens at
midnight that would change a setting affecting Project's ability to
open a file with no user logged on.

Any hints or suggestions would be appreciated.


Thanks
Dave

.

Relevant Pages

  • Re: What is the story with Server Busy
    ... If an activeX control calls your app then it will wait for ever without showing a message, but if something cross process calls your app and doesn't get a response then the message will appear. ... I put up a form for an error, and if I click on a button to debug then I return from the call to the error handler with a result code to execute the following: ... This highlights probably the BIGGEST problem in linking complex applications together via ActiveX controls, that you reach a level of complexity where you just can't tell what is causing problems. ... The original ANSI standard for C was delayed for one year - by me and two other people who were pushing hard to tighten up several things like its screwed up order of operations and arguments types in calls. ...
    (microsoft.public.vb.enterprise)
  • RE: Form load failed
    ... > My standard forms library has disappeared. ... > button, and the design form dialog opens, but no standard forms are shown. ... > Once the design form dialog box is open I can open other libraries like my ...
    (microsoft.public.outlook.program_forms)
  • Form load failed
    ... My standard forms library has disappeared. ... button, and the design form dialog opens, but no standard forms are shown. ... Once the design form dialog box is open I can open other libraries like my ... rename Outcmd.dat file and restart Outlook ...
    (microsoft.public.outlook.program_forms)
  • Re: INQUIRE - FORM vs. (UN)FORMATTED
    ... restated what th e standard said without even changing the words much. ... Now most current operating systems don't have a good way to tell. ... Fortran run-time library. ... was such that only one of the opens would work, ...
    (comp.lang.fortran)
  • Re: F2003 access=stream question
    ... >>I imagine that for most implementations, ... >>standard gives you no guarantees. ... >>opens the file for sequential access, ... >>statement opens it for stream access. ...
    (comp.lang.fortran)