Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2000
    Location
    Rockhampton, Queensland, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Register ActiveX (O2K SR1 )

    I have imported forms and code from a working database to the one I'm developing. In the DB I'm now working on, the command to activate an Excel workbook results in Error 429. Help suggests the ActiveX needs registering, but what do I register and how do I know what is or isn't registered? VBA References are the same in both databases.

    TIA
    Neville

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Register ActiveX (O2K SR1 )

    There is a Knowledge Base article that might help:
    http://support.microsoft.com/support/kb/ar...s/Q244/2/64.ASP<A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q244/2/64.ASP>Q244264- TroubleShooting Error 429 When Automating Office Applications</A>

  3. #3
    New Lounger
    Join Date
    Dec 2000
    Location
    Rockhampton, Queensland, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Register ActiveX (O2K SR1 )

    I still need help. What has got me bluffed is that the same code works in my working database on the same PC.

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Register ActiveX (O2K SR1 )

    Neville,
    You've probably already done this but just in case ... When you checked that the references were the same in both databases did you also check that the Location: paths at the bottom of the references window point to the identical paths and file names? e.g. OLE automation on my machine points to C:WINNTSystem32stdole2.tlb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •