Results 1 to 2 of 2

Thread: Class not registered error

  1. #1
    Neophyte chrismurray217's Avatar
    Join Date
    Nov 2018
    Posts
    2
    Articles
    0
    Excel Version
    2016 64-bit

    Class not registered error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    We've recently been upgraded to Windows 10, and Microsoft 2016, and i'm getting a "Class not registered" error when it gets to the "Catalog.Create dbConnectStr" section of the code.

    Does anyone know what needs to be updated for this to work in this new environment?

    Thanks
    Last edited by Pecoflyer; 2018-11-13 at 05:41 PM.

  2. #2
    Neophyte chrismurray217's Avatar
    Join Date
    Nov 2018
    Posts
    2
    Articles
    0
    Excel Version
    2016 64-bit
    Quote Originally Posted by chrismurray217 View Post
    We've recently been upgraded to Windows 10, and Microsoft 2016, and i'm getting a "Class not registered" error when it gets to the "Catalog.Create dbConnectStr" section of the code.

    Does anyone know what needs to be updated for this to work in this new environment?

    Thanks
    Update:

    I changed the Connection String:

    Code:
    dbConnectStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";"
    to:

    Code:
    dbConnectStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & dbPath & ";"
    ...and it seems to be working.

    Thanks,
    Chris

Posting Permissions

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