Re: References in vba

CenturionX <darwinbaldrich@xxxxxxxxx> wrote:

I'd like to know what references in my vba code are used or not.

I work in a code made by another person previously, i founded to many
references and i believe that someones are not used.

I'd like to optimize the application ereasing the useless references.

What version of Access? Are you using ADO or DAO or both?

Do you have any references besides the basic three? Are you sure you need them?
Write down the path and name of the extra ones (or put the following code in a module
and execute the code), delete from the references list and Compile and Save All.
Keep any necessary references and ensure they are distributed to the target system.

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major & "." & ref.Minor
Next ref

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

The Access 2002 default references when the MDB is created in Access
2000 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library.

The Access 2003 default references when the MDB is in A2000 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library

The Access 2003 default references when the MDB is in A2002/A2003 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Invalid Procedure Call
    ... Microsoft Access 9.0 Object Library ... Microsoft ActiveX Data Objects 2.1 Library ... "Van T. Dinh" wrote: ... > Have you check the References of your database? ...
    (microsoft.public.access.queries)
  • Re: References change when using CreateDatabasem ?
    ... Microsoft Access 9.0 Object Library ... Microsoft Visual Basic for Applications Extensibility 5.3 ... What references should I have, are these the standard References for A2K ... The database saves a selection of its data to an external database file - ...
    (microsoft.public.access.modulesdaovba)
  • Re: Error after upgrade
    ... I suspect this is more of a references problem. ... Visual Basic for Applications ... Microsoft Access 11.0 Object Library ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.conversion)
  • Re: DAO Error
    ... I am converting to Access 2000. ... Here is the list of references selected. ... Microsoft Access 9.0 Object Library ... Microsoft Visual Basic or Applications Extensibility 5.3 ...
    (microsoft.public.access.conversion)
  • Re: Distributing an MDE
    ... Do you have any references besides the basic three? ... For Each ref In Access.References ... The Access 2003 default references when the MDB is in A2000 format are ... Microsoft Access 11.0 Object Library ...
    (microsoft.public.access.developers.toolkitode)