[RESOLVED] Adox and accdb-VBForums
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
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,496

    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
    39,720

    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
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    98,267

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  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
  •  



Featured


Click Here to Expand Forum to Full Width