Results 1 to 3 of 3

Thread: Compiler error: ActiveX component can't create object on Apple computer

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 2012
    Posts
    58

    Compiler error: ActiveX component can't create object on Apple computer

    My project written in VB 6.0 under Windows 10 is working perfectly.
    When I use the same project on An Apple computer with VB 6.0 under Windows 10, I get the compiler error : "ActiveX component can't create object" in the following part of code, referring to OpenDatabase

    Dim db As Database
    Set db=OpenDatabase(App.path & "\data1.mdb,false,false)

    I have selected the following references:

    Visual Basic For Applications
    Visual Basic runtime objects and procedures
    Visual Basic objects and procedures
    OLE Automation
    Microsoft Data Formatting Object Library 6.0 (SP6)
    Microsoft Data Binding Collection VB 6.0 (SP4)
    Microsoft Data Report Designer 6.0 (SP4)
    Microsoft Scripting Runtime
    Microsoft Office 16.0 Access database engine object library
    Microsoft ActiveX Data Objects 2.8 Library
    Microsoft ActiveX Data Objects Recordset 2.8 Library
    Microsoft WinHTTP Services, version 5.1
    Microsoft XML, v6.0

    If I add the reference "Microsoft DAO 3.6 Object Library" then I get the error "Name conflicts with existing module, project, or object library"

    Any suggestions?

  2. #2
    PowerPoster yereverluvinuncleber's Avatar
    Join Date
    Feb 2014
    Location
    Norfolk UK (inbred)
    Posts
    3,560

    Re: Compiler error: ActiveX component can't create object on Apple computer

    I suggest that somehow that the module has been manually registered and possibly incorrectly. You could try de-registering it.

    First of all though, look in the .frm and extract the line that corresponds.

    It may look somewhat similar to this:
    Object = "{13E244CC-5B1A-45EA-A5BC-D3906B9ABB79}#1.0#0"; someText

    You will have to identify the line in question.

    Close the IDE, edit and identify the line, copy, store it, then remove it using an external editor. Re-open the project and then try to re-add the DAO 3.6 using the IDE.
    https://github.com/yereverluvinunclebert

    Skillset: VMS,DOS,Windows Sysadmin from 1985, fault-tolerance, VaxCluster, Alpha,Sparc. DCL,QB,VBDOS- VB6,.NET, PHP,NODE.JS, Graphic Design, Project Manager, CMS, Quad Electronics. classic cars & m'bikes. Artist in water & oils. Historian.

    By the power invested in me, all the threads I start are battle free zones - no arguing about the benefits of VB6 over .NET here please. Happiness must reign.

  3. #3

    Thread Starter
    Member
    Join Date
    Nov 2012
    Posts
    58

    Re: Compiler error: ActiveX component can't create object on Apple computer

    thank you, that was the answer

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width