Class not registered error

chrismurray217

New member
Joined
Nov 13, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2016 64-bit
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 a moderator:
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
 
Back
Top