Forcing a Reference?

[ChrisBat]

I don't know that this is the right newsgroup, but I'll
give it a shot.
I need to ensure that a user has Microsoft's ActiveX Data
Objects 2.5 Library selected under the References in VBA
(maybe this should go in the ActiveX newsgroup - I'll post
it there to...)
How do I ensure that this reference has been selected
prior to the database opening? I need an easy way to do
this, and if the person does not have it referenced,
either to reference it programmatically or an error
message to pop-up asking the user to call me. I would
normally go around and ensure that the individuals using
the DB have the reference, but there are going to be users
in other buildings using this database, and I don't have
time/resources to do this.
Any suggestions?
Thanks,
Chris

 

[Rick Brandt]

I don't know that this is the right newsgroup, but I'll
give it a shot.
I need to ensure that a user has Microsoft's ActiveX Data
Objects 2.5 Library selected under the References in VBA
(maybe this should go in the ActiveX newsgroup - I'll post
it there to...)
How do I ensure that this reference has been selected
prior to the database opening? I need an easy way to do
this, and if the person does not have it referenced,
either to reference it programmatically or an error
message to pop-up asking the user to call me. I would
normally go around and ensure that the individuals using
the DB have the reference, but there are going to be users
in other buildings using this database, and I don't have
time/resources to do this.
Any suggestions?

The references "go along" with your MDB. Anyone using your app will
automatically have those references set in the file because _you_ set them
before you gave them a copy.

The issue is whether those references will be properly resolved on their PC
and your app has no way of "forcing" anything in that regard. You can
check for missing/broken references at startup, display a message, and then
close when any are found.