Re: Late Binding

Thanks,

What about the AciveX reference?

Since I took out the code that deals with using the ActiveX email client I
am not aware that I am using any ActiveX.

I still have the smtp ActiveX client registered with Windows.

Any ideas

"Douglas J. Steele" wrote:

DAO 3.6 is the correct reference for Access 2000, Access 2002, Access 2003
and Access 2007 (when not converting to the Access 2007 ACCDB file format)

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


"tmort" <tmort@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DDA48267-ADBE-4D03-9F53-41BA9DD5971F@xxxxxxxxxxxxxxxx
So are you saying that DAO is not version specific and 3.6 will work with
older installation?

"tmort" wrote:

I have an Access db developed with Access 2003 that will work (with
adjustments to references) with 2002 and 2000. Presumeably it will also
work
with Ofice 2007.

So far I've manually adjusted references for each machine I install it
on.
I'm told that I should look into late binding. I've found some
discussions
on how to do this with Excel and Outlook. It looks like I change the way
I
call thse by changing as object to application or vice versa where I call
them.


I'm pretty sure that I've had to change some of the other references as
well
and I don't know if I can use late bindings with the others or how.


The references I use are:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 2.5/3.51 Compatibility Library
OLE Automation
Microsoft ActiveX Data Objects 2.7 Library
Microsoft Excel 11.0 Object Library
Microsoft Outlook 11.0 Object Library

Can someone help me with this? I saw another post that says to look at
the
MVP site, but, I haven't been able to locate it.

Thanks




.

Relevant Pages

  • Working form has stopped working: Repost and Update
    ... Microsoft updates may have created the problem. ... I have inventoried the References listed in the Visual Basic window. ... There are four libraries mentioned. ... Microsoft Access 11.0 Object Library ...
    (comp.databases.ms-access)
  • Working form has stopped working
    ... Microsoft updates may have created the problem. ... I have inventoried the References listed in the Visual Basic window. ... There are four libraries mentioned. ... Microsoft Access 11.0 Object Library ...
    (comp.databases.ms-access)
  • Re: question about references
    ... There is no native method provided to set default references. ... the Windows Common Controls reference...otherwise, ... > Microsoft Access 9.0 Object Library ... > Microsoft ActiveX Data Objects 2.1 Library ...
    (microsoft.public.access.modulesdaovba)
  • Re: Set up Parameter Query to accept more than one entry
    ... > Checking References under the Tools Menu the following references are ... > Microsoft Access 11.0 Object Library ... > Microsoft Visual Basic for Applications Extensibility 5.3 ...
    (microsoft.public.access.queries)
  • Re: Undefined function Left in expression
    ... Applications and Microsoft Visual Basic for Applications Extensibility 5.3. ... I've added a random reference and removed it to refresh the references and ... Microsoft Access 10.0 Object Library ...
    (microsoft.public.access.queries)