Autodetect VB Script's References?

[Tezcatlipoca]

This is something of a shot in the dark, but does anyone know if it is possible to have a database automatically detect the VB references currently installed?

The reason I ask is that I have just finished writing a database with some farily advanced fuctions coded into it. Now most of these require the 'Microsoft Access 11.0 Object Library' in order to function properly...

...however, some of the people who this database was written for seem to still have the 'Microsoft Access 9.0 Object Library' plugged in. Now I can update their PCs manually, of course, but is there any way for Access to tell if they have the older version and take action accordingly?

 

[ghudson]

I have seen it somewhere. Google it and I bet you find it.

 

[Tezcatlipoca]

thanks, GHudson, but I really am having trouble tracking this down. I've also encountered a new problem where, with some client's machines (still running Office 2000 and thus possessing the Access Object Library 9.0), I am unable even to manually update them by simply copying the 11.0 file over (a trick which did work with some).

I am now totally stuck with three people out of 20 not being able to use the database at all, since their object libraries are too old.

Can anyone help?

 

[ghudson]

Searching really does work.

Check this out...
http://home.bendbroadband.com/conradsystems/accessjunkie/references.html

The top link @ accessmvp.com on that page lists some code that should help you.

I did not check out the other links at the above site but I am sure they will lead you in the right direction.

 

[Tezcatlipoca]

Searching really does work.

Indeed, but bear in mind that not finding the same results as you is far from indicative of not searching. I hunted high and low but was unable to find precisely what I needed; however, your link is very handy, thankyou!