Which Object Library

[Nigel Scott]

How do you tell which object library is being referenced by an
application.

For example, I have two versions of mso.dll on my computer in the
following locations:
c:\program files\common files\microsoft shared\office10
c:\support\officexp_a\pfiles\common\msshared\office10

Similarly, there are four instances of dao360.dll:
c:\program files\common files\microsoft shared\dao
c:\support\officexp_a\files\osp\1033\files\pfiles\common\msshared\dao
c:\winnt\$ntuninstallkb829558$
c:\winnt\servicepackfiles\i386

How can I tell which is being currently referred to, and do I change
references using regsvr?

Thanks for any info

Nigel

 

['69 Camaro]

Hi, Nigel.

You can check an Access application's libraries either visually or
programmatically. To check visually, first open a code module in the VB
Editor, then select the Tools menu -> References to open the References
dialog window. There you'll see the list of libraries your application is
using, which is indicated by a check mark next to the library's name.

To find out the path and file name of each of these libraries, select the
name of any of these libraries with your mouse. Near the bottom of the
References dialog window, you'll see the exact path and file name of the
library you selected in the "Location:" label.

Using RegSvr registers an ActiveX control or object library in the Windows
Registry. It's very rare that this is ever needed after you've installed
Microsoft Office, so you should probably leave this alone unless you are
experiencing a lack of "normal" functionality between Access and other
applications in the Office suite. (And if that's the case,
uninstall/reinstall of Office is probably the better way to go.)

To change a Reference library for your application, use the References
dialog window to add, delete or move up or down any of the References
listed. Unless you are experiencing problems with a missing Reference, then
you will probably only ever use this dialog window to add new References or
change the ADO and DAO library heirarchy order when beginning a new database
application. The References at the top of the list are the Access built-in
References, and cannot be changed.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that
a message will be forwarded to me. Spammers who use my UNALTERED
reply E-mail address will only satisfy the SpamEater's hunger.)