Access-Project automation under Server03 Standard

D

dgmoore

I have an Access app that controls MSProject to generate Gantt charts.
We are attempting to run this process automatically on a server as a
scheduled job. The process works correctly when launched by a logged-on
user, but fails at the first call from Access to Project when launched
by a script with no user logged on.

We suspect this may be a Windows/Server03 security issue having to do
with credentials not being passed correctly if no user is logged on.

Does this make sense, or might there be another explanation? Is there a
way in VBA to pass credential info from Access to Project, such as Run
As or something similar?

Thanks
Dave
 
Top