dynamic input tool not working-security patch error

[markstephens]

Hi most members of my team cannot run a dynamic input tool that reads in .xlsx files

We get the following error

Error: Dynamic Input (4): The 2017-10-10 Windows security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver

Not all of us do however, some can run it fine. There is no apparent reason why some can and some cannot.

ive scoured the community and not found a consistent answer.

is this an IT issue that our IT department can deal with, and if so,  what do we tell them?

all help appreciated!

thanks

mark

[drew9 · Accepted solution]

Hi @markstephens ,

I've had this same issue before. You will have to install the access driver. Please refer to this link for more details: https://community.alteryx.com/t5/Engine-Works/Access-Driver-Install-for-xls-File-Acess/ba-p/90145

[markstephens]

thanks for the reply

i will pass the comments on to our Alteryx support in IT and see if it works, if so, i'll accept as a solution.

thanks

mark

[markstephens]

i got IT to instlal 32 bit Access Database Engine and it now works

ive no idea what this means, but i asked and they did it, and it works which is all i care about

cheers