Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    ActiveX control (2002)

    I had to reinstall Windows recently, now my database on the network says 'ActiveX component can't create object' when I try to log in. Everyone else can use it ok. How do I find out what AciveX control it's after, as I can't get any further? HELP

    Rob

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    The error message is misleading; it probably is not caused by an ActiveX control. Some possibilities:

    Re-register DAO 3.6:
    - In Windows, select Start | Run...
    - Type regsvr32 "C:Program FilesCommon FilesMicrosoft SharedDAODAO360.DLL", then press Enter.

    Re-install MDAC:
    - You can download a recent version of MDAC here.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ActiveX control (2002)

    I've tried that, still not working, but on another database that does'nt need login, I get an error message on the line 'Set con = Application.CurrentProject.Connection', which is highlighted. It's the same on two or three databases.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    Open one of the databases you can get into, with the Shift key held down to bypass the startup options (if possible).
    Activate the Visual Basic Editor (Alt+F11)
    Select Tools | References...
    If you see one or more references starting with MISSING, note which ones they are, then clear their check boxes and click OK.
    See if this removes the problem.
    If not, could you post the following information:
    - Which references were checked.
    - Which ones (if any) started with MISSING.
    Thanks.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ActiveX control (2002)

    None are marked MISSING, but the only ones ticked are :-
    Visual Basic For Applications
    Microsoft Access 10.0 Object Library
    Microsoft DAO 3.6 Object Library
    OLE Automation
    Microsoft Visual Basic For Applications Extensibility 5.3

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    Aha, so these databases were converted from an earlier version (probably Access 97), but also use Access 2000/2002 features.
    Untick the OLE Automation and Microsoft Visual Basic for Applications Extensibility 5.3 references, I'm 99.99% sure that you don't need them.
    Also untick the Microsoft DAO 3.6 Object Library (it may turn out that you need this one after all)
    Add a reference to Microsoft ActiveX Data Objects 2.n Object Library, with the highest n available.
    Click OK, then select Debug | Compile projectname
    Do things work OK now?

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ActiveX control (2002)

    When I untick DAO 3.6 Object Library, I get a compile error which points to a line in my Database which reads 'Dim db As DAO.Database', but with it ticked, it still does'nt work

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    OK, so you do need the DAO library. What happens if you select Debug | Compile ... with DAO 3.6 ticked?

  9. #9
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ActiveX control (2002)

    I still get the error, which runtime 429.and 'Set con = Application.CurrentProject.Connection' highlighted

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    One last suggestion: try Help | Detect and Repair. If that doesn't help either, I would wait a bit to see if others come up with better ideas, and if not, do a complete uninstall and reinstall of Office.

  11. #11
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ActiveX control (2002)

    Can't find detect and repair. Going to have to reinstall Office, see if that works. Thanks anyway Hans.

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ActiveX control (2002)

    Make sure that you see full menus - there is a setting for this in the Options tab of Tools | Customize... See screenshot.
    Attached Images Attached Images
    • File Type: png x.PNG (16.0 KB, 0 views)

Posting Permissions

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