Can't Create Data Source Object - Access Database

I have a workflow I've used for years without issue. It opens an access database query and then does a bunch of other stuff. 🙂

Today when I try to run it, the Input Data that opens MS Access gives me the Error Opening Connect String: Can't Create Data Source Object, but no other info.

I've opened the database itself and run the query, so I know it works.

Suggestions? Running 2019.4.8.22007

Input

Accepted answers

TeamTJ

Turns out, for some bizarre reason, I had to install Access Database Engine 2010 64bit.

It's working now.

Life is strange.

All comments

messi007

Dear @TeamTJ,

Have you tried to delete the output table and recreate it:

I think that the error is because that some data type changed in the workflow.

Let me know if the resolve your problem.

Regards,

TeamTJ

I don't have that option, and don't think I should. The source is just a select query in Access.

Untitled.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703