Macro fails to run at start up

[Guest]

I have a database on a network that is shared by client PCs who have a
shortcut to the file on their desktops. There is a macro that runs at startup
that does not seem to run on one PC.

Normally we have been able to add a shortcut to a PC to allow them to access
the database but on one PC (we have just set up with XP sp2 and office 2000
sp3) it gives the following error:

The expression on open you entered as the event property setting produced
the following error:
Object of class does not support the set of events

I cant understand why we have this message as it works fine on other PCs
with the same software and service packs installed. Anyone know what could be
wrong? Thanks.

 

[Guest]

One suggestion to start the troubleshoot,

-Open one module (or create a new one if you do not have any) in the source
database.
-Select References from the Tools menu in the VB window
-Verify that both computers have the same references, if they are different
match the non-working pc to the one that works,

 

[Guest]

Thanks for that - I have checked and both references are identical. The
Access installations are also identical, and I am lost as to what could be
wrong. Any further ideas? Thank you.