References- How to get rid of them!

[Lauren Quantrell]

I'd down to four references in my Access2K .adp project.
I know I can't get rid of two of them: Visual Basics for Applications
and Access 9.0 Object Library.

But, can I get rid of:
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

I have used late binding to get rid of the reference to the Outlook
library. Is there something similare I can do to get rid of the two
above?

I don;t even use ActiveX components but the project doesn't compile
without it.

Thanks,
lq

[polite person]

On 5 Oct 2005 14:26:58 -0700, "Lauren Quantrell" <la************ *@hotmail.com> wrote:

I'd down to four references in my Access2K .adp project.
I know I can't get rid of two of them: Visual Basics for Applications
and Access 9.0 Object Library.

But, can I get rid of:
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

I have used late binding to get rid of the reference to the Outlook
library. Is there something similare I can do to get rid of the two
above?

I don;t even use ActiveX components but the project doesn't compile
without it.

Thanks,
lq

I have a feeling that the OLE one is ued for internal functions such as time and date
though I could be wrong

[Douglas J. Steele]

Access must have those two references to run.

What are you hoping to accomplish by getting rid of them?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Lauren Quantrell" <la************ *@hotmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I'd down to four references in my Access2K .adp project.
I know I can't get rid of two of them: Visual Basics for Applications
and Access 9.0 Object Library.

But, can I get rid of:
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

I have used late binding to get rid of the reference to the Outlook
library. Is there something similare I can do to get rid of the two
above?

I don;t even use ActiveX components but the project doesn't compile
without it.

Thanks,
lq

[Lauren Quantrell]

I'm just wondering if there's a way to use declarations and call
libraries that I'm actually using instead of using the references.

[lylefair]

>From MSDN:
Visual Basic Language Concepts
Early and Late Binding

The Visual Basic compiler performs a process called binding when an
object is assigned to an object variable. An object is early bound when
it is assigned to a variable declared to be of a specific object type.
Early bound objects allow the compiler to allocate memory and perform
other optimizations before an application executes....

By contrast, an object is late bound when it is assigned to a variable
declared to be of type Object. Objects of this type can hold references
to any object, but lack many of the advantages of early-bound
objects....

You should use early-bound objects whenever possible, because they
allow the compiler to make important optimizations that yield more
efficient applications. Early-bound objects are significantly faster
than late-bound objects and make your code easier to read and maintain
by stating exactly what kind of objects are being used. Another
advantage to early binding is that it enables useful features such as
automatic code completion and Dynamic Help because the development
environment (IDE) can determine exactly what type of object you are
working with as you edit the code. Early binding reduces the number and
severity of run-time errors because it allows the compiler to report
errors when a program is compiled.

[Douglas J. Steele]

Sure, that's a reasonable thing to do for many references, but as far as I
know, you cannot remove all of the references, as Access itself needs them.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Lauren Quantrell" <la************ *@hotmail.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .

I'm just wondering if there's a way to use declarations and call
libraries that I'm actually using instead of using the references.

[david epsom dot com dot au]

1) The references have a .builtin property. If this
property is true, they are built in, and cannot be
removed.

2) Those references are just type libraries anyway
- the actual code is built into access, not dynamically
linked.

(david)

"Lauren Quantrell" <la************ *@hotmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I'd down to four references in my Access2K .adp project.
I know I can't get rid of two of them: Visual Basics for Applications
and Access 9.0 Object Library.

But, can I get rid of:
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

I have used late binding to get rid of the reference to the Outlook
library. Is there something similare I can do to get rid of the two
above?

I don;t even use ActiveX components but the project doesn't compile
without it.

Thanks,
lq

[Lauren Quantrell]

So then the fewest number of references I can have for any .ADP project
in Access is four?
lq

Visual Basics for Applications
Access 9.0 Object Library.
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

???

[aaron.kempf]

i remove OLE all the time and i dont have problems.

and just for the record; it seems like you always SHOULD use the latest
ADO.. within reason. i dont mean 2.8-- i mean 2.5--- > since that is
standard with Windows 2000 and XP it seems like a fair upgrade.

[david epsom dot com dot au]

I don't use ADP's. If those references are .BuiltIn
in ADP's, then you can't remove them. In MDB's the
OLE and ADO type libraries aren't built in, and the
type libraries can be late bound if you wish to use
them. ADO is built into Access, so you have limited
use of ADO in an Access MDB without using the type
library if you wish to do so.

Because of the structure of the ADO objects, ADO without
the ADO type library is less useful than DAO without
the DAO type library.

(david)

"Lauren Quantrell" <la************ *@hotmail.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

So then the fewest number of references I can have for any .ADP project
in Access is four?
lq

Visual Basics for Applications
Access 9.0 Object Library.
OLE Automation (stdole2.tlb)
Microsoft ActiveX Data Objects 2.1 Library (msado21.tlb)

???