Connection Error when connecting Input Data to Access database

[TeamTJ]

I have a workflow I've been using for a couple years without issue.

Today when I tried to run it I get an error on the Input Data that opens the query in Access.

Connection Error:

External Component has thrown an exception

I tried adding a new Input Data to that file, same error.

I open the database and it looks fine.  I've even compacted it.

I've also tried connecting to a brand new database with no luck.

Suggestions?

[messi007]

@TeamTJ,

Please take into this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/2019-1-Designer-Unstable-and-Throwing-... 

Hope this helps!

Regards

[TeamTJ]

I did the RegEdit and no change.

This only happens with access database...excel files seem to work just fine.

[LisaL]

@TeamTJ 

Did you ever resolve this problem?  There are a few approaches that have been helpful to other users

• When using Access or Excel you might find that you need to install the Microsoft Access Database Engine Redistributable 2010 32-bit.
• Reinstall software (You might want to do a complete uninstall first, but back up the Alteryx directories or just rename them rather than deleting them if you have been working in Alteryx for a while.)
• Test to see whether you observe the same issue when you disable your AntiVirus software.