Forcing a Reference?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisBat - 04 Oct 2004 14:19 GMT

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

Reply to this Message

Rick Brandt - 04 Oct 2004 20:58 GMT

> I don't know that this is the right newsgroup, but I'll
> give it a shot.
[quoted text clipped - 12 lines]
> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message