Re: Which Object Library

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.org)
Date: 08/20/04


Date: Fri, 20 Aug 2004 15:10:26 -0700

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.)

"Nigel Scott" <nigel.scott@nottscc.gov.uk> wrote in message
news:a047c7ce.0408200556.63aba72@posting.google.com...
> 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



Relevant Pages

  • RE: Built in function errors.
    ... I have yet to work with 2007 and certainly not in a mixed environment. ... I've replaced UCase intrinsic function located in the Control ... ways of trying to match all the libraries but so far nothing has worked 100%. ... It is probably that these issues are not related to references. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Built in function errors.
    ... I've replaced UCase intrinsic function located in the Control ... ways of trying to match all the libraries but so far nothing has worked 100%. ... It is probably that these issues are not related to references. ... updating the software on the client computer and reselecting all ...
    (microsoft.public.access.modulesdaovba)
  • Re: YASID: Gargoyles, but no rats
    ... There were some references to, I think, gargoyles that had ... libraries in town. ... or in the agents of a God. ...
    (rec.arts.sf.written)
  • Re: cycle through a table
    ... Doug Steele, Microsoft Access MVP ... "Phil" wrote in message ... >> program and object libraries that provide functionality that may be ... References to the specific library files, ...
    (microsoft.public.access.modulesdaovba)
  • Re: cycle through a table
    ... module as is: you have to run the SQL code using something like: ... >>>> program and object libraries that provide functionality that may be ... References to the specific library files, ... then go back in and unselect the reference you just added. ...
    (microsoft.public.access.modulesdaovba)