Can't run PPro macro on server

[jpuls]

We have an installation of MSPS 2003 along with MS ProjectPro 2003, all
with the appropriate service packs. To meet some particular needs, we
have automated some tasks by writing a few macros that are run in
Project Pro. When run from any of the client PCs, these macros work
fine.

We have also installed Project Pro on the server itself. When we
attempt to run one of the macros from Project Pro on the server, it
stops on the line "Dim cn As ADODB.Connection", and we get an error
message "Compile error: User-defined type not defined". This is because
the macro has a reference to the Microsoft ActiveX Objects 2.8 Library
(msado15.dll). This reference is missing from the macro. When we
attempt to add the reference in to the macro, we can't do it. The macro
fails, and the next time we open up the macro in Project Pro on the
server, we have the same problem.

Now, the macro runs on every client PC, just not on the server. I'm
figuring that there is a setting somewhere on the server which is
stopping it from running, but I don't know what it is.

Any help would be appreciated.

Thanks,

Jim

 

[Rod Gill]

I assume the server has MDAC 2.8 installed and that it's Server 2003?

 

[jpuls]

Rod,

Thanks for your post. We ran comcheck on the machine, and it came out
clean: MDAC 2.8 with SP2 on Server 2003 with SP1. The individual
components showed no mismatch. Since the previous post, we have found
that one of the IT people can run the macro on the server, but that no
one else can do so, even another person with the same rights ... as far
as we know. So this is the path we are on now.

Best,

Jim

 

[jpuls]

For others who might view this in the future, we "solved" the problem
by copying the user's profile to other users. Not a real satisfying
solution!