Can't Create Data Source Object - Access Database

[TeamTJ]

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

[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.

[TeamTJ · Accepted solution]

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

It's working now.

Life is strange.