Results 1 to 6 of 6

Thread: [RESOLVED] Adox and accdb

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 2008
    Posts
    57

    Resolved [RESOLVED] Adox and accdb

    Hello Sirs,

    i have a code to make an access (.accdb) database programmtically using
    ADOX.

    it works here in my pc but when i try to install to other pc that dont have ms access 2007 installed it says "Class not registered"

    i can think that this is an ms access version issue because i tried to create .mdb and it works fine without any errors.

    now my question is what file should i copy to other pc to avoid this problem?

    thnx

  2. #2
    gibra
    Guest

    Re: Adox and accdb

    If Office 2007/2010 (with MSAccess) isn't present, then you must install the:

    2007 Office System Driver: Data Connectivity Components
    http://www.microsoft.com/downloads/e...2-ef94e038c891


  3. #3
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Adox and accdb

    Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: Adox and accdb

    By way of further explanation, it works with an MDB file because it uses the Jet engine to create the file and Jet is installed with Windows. The Access Connectivity Engine is not installed by default with any version of Windows, so it must be installed as part of Access itself or as a separate component as suggested by gibra. It's not a matter of just copying a file though. It requires installation.

  5. #5

    Thread Starter
    Member
    Join Date
    Nov 2008
    Posts
    57

    Re: Adox and accdb

    @gibra: Thank you so much sir.. its working now.
    @jmcilhinney: i really like your explanation sir it is very helpful.

  6. #6
    New Member
    Join Date
    Apr 2018
    Posts
    1

    Re: [RESOLVED] Adox and accdb

    Hi,

    I am also facing this issue : "Class not registered" with office 2016.
    As per my understanding, i have to install Data connectivity components"

    can any one help me,exactly what steps i have to follow to resolve this issue.

    Thanks

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