Hi,
I built a workflow a few years back which extracts the data from an Access table and utilizes it within Alteryx to combine with additional information.
It obviously worked fine when I built it. I loaded it to the Prod server years ago and it has run successfully every week ever since.
Today, I went into the workflow to review something about the process that takes place and I immediately get error when I open the tool. (See Existing Input Error.png)
I clicked into the Configuration window and hit the "..." button to the right of "3. Table or Query" to see what was available. The pop-up window shows the table name in SQL Editor button. When I select the Tables button, it says "Get Table List Error: Error Opening connect string: Unknown error". Beneath that box it says "Table List is Cached. Last Refresh 06/09/2014 at 11:00AM. Only problem here is that the Access Database was built 3 years later and the workflow was built in 2018. (See Weird Last Cache Date.png)
I also tried the refresh button. That doesnt work.
I tried deleting and rebuilding the input tool and I get a pop-up saying "Connection Error: External component has thrown an exception" (See Input Connection Error.png)
I am stumped. It works on the Server AND i can also open the Access database and move around in it no problem. Not sure why Alteryx can no longer connect to it.
Any suggestions?
