Error Opening Connect String

[Vyx]

Hi All

So I followed the below article to create a workflow that dynamically selects files to pull into a workflow. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-choose-files-for-input-dat...

However, after a recent software upgrade I keep receiving the following error:

Error Opening Connect String: Can't create Data Source Object

Having done some research within the Alteryx community I have a found a few articles referencing the same issue but having installed the Microsoft driver the issue is still happening.  

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-opening-connect-string-Can-t-cre...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Message-Error-opening-connect-st...

Can't share the workflow as my work prevents me from uploading any files unfortunately. 

Thank you in advance for all your help! 

Kind Regards,

V

[KOBoyle · Accepted solution]

@Vyx I had this issue a couple of years ago. At the time that I downloaded the DB Engine, the version was 2010. Now, it looks like the current version is 2016. You may want to try installing the 2010 version that I found at the link below.

Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Cent...

-K