Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    13

    Unhappy Runtime Error '429' ActiveX Component Can't Create Object


    Hi,

    I have created an application which uses Excel as the front end and saves the data to a MS Access database, within this application are several stand alone reports which when opened up calls in data from the database and shows the data in charts and graphs etc. The users can select different timescales in which they want to view the data.

    My problem is that all this was working fine until one day i go to open up one of the reports and the error Runtime Error 429 ActiveX Component can't Create Object. This has happened to all the reports and application, no changes have been made to suggest any obvious problems, also this only occurs on my machine if anyone else opens it up on there machine it works fine. Anyone with any ideas to this problem it would be most appreciative.

    Cheers

    Jay
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,489
    Rep Power
    4540
    This error usually means a registered component isn't registered any more, or a newer version of a component superseded a previous version that your app is looking for.

    You need to identify what code is causing the error.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  4. #3
  5. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    It's Doug G - Hi Doug G! wivell - are you creating an ActiveX in code, or in the designer? Try finding the ActiveX on your harddrive (.ocx file). Then use the fully qualified file name for xxxx in the following statement typed from "Run" on the start menu...
    Code:
    regsvr32 "xxxx.ocx"
    Then try to run it again.
  6. #4
  7. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,489
    Rep Power
    4540
    Hey, Fisherman is back!
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  8. #5
  9. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    yeah - short hiatus. been learning lots of new stuff - C#, Oracle, Crystal, Perl, Java, EJB...blahblahblah. Not a lot of time to get online anymore. Wivell - did you get it worked out?
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    13
    Ive done a search for *.OCX files within Microsoft Office folder and done a regsvr32 "xxxx.OCX" on all of the OCX files, the message that kept coming up with all the OCX files was LoadLibrary("C:\Program Files\Microsoft Office\Office"xxxx.OCX") Failed - The specified module could not be found.

    Is there anything else i can try because, or will it end up in re-building my machine as ive tried several re-installing office several times.
  12. #7
  13. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    what's the name of the ocx that you are trying to access. I'll see if there's some specific problem.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    13
    What i did was searched the office folder and found a lot of ocx files, im unsure which one i was using so i tried registering them all, and the same message kept coming up. Here is a list of all the ocx files i tried registering.

    MSCAL.OCX, OUACTRL.OCX, HTMLMARQ.OCX, HTMLMM.OCX, SNAPVIEW.OCX, ASFCHOP.OCX, EYEDOG.OCX, MSIAV.OCX, MSICDROM.OCX, MSIHWNFO.OCX, MSIOFF9.OCX, MSIOLERG.OCX, MSIPRINT.OCX, MSISYS.OCX, TXTVIEW.OCX, FPATL.OCX

    Is that what you meant for me to do?
  16. #9
  17. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    not exactly. Those ocx files are already registered, or Office wouldn't work at all. Run the code in debug, step line-by-line until it breaks, then copy and paste the line that broke into this forum.
  18. #10
  19. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    13
    Right okay, i've stepped through the code and the line that broke is Set wrkJet = DBEngine.Workspaces(0).
  20. #11
  21. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    are you using DAO objects to access the data?
  22. #12
  23. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    13
    No im not using DAO objects
  24. #13
  25. Inherits Programmer.Slacker
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Aug 2003
    Location
    Between my Id and your Ego
    Posts
    2,351
    Rep Power
    0
    Doug - do you have any ideas here?
  26. #14
  27. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,489
    Rep Power
    4540
    Right okay, i've stepped through the code and the line that broke is Set wrkJet = DBEngine.Workspaces(0).
    This is a DAO object you're trying to create so you are using DAO, or at least trying to use DAO.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  28. #15
  29. Type Cast Exception
    Devshed Supreme Being (6500+ posts)

    Join Date
    Apr 2004
    Location
    OAKLAND CA | Adam's Point (Fairyland)
    Posts
    14,956
    Rep Power
    8618
    So maybe this could all be resolved by referencing:

    Microsoft DAO 3.x Object Library
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo