Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

TDCB-4655: Access 32bit drivers fail in tool config but runtime works for xlsb and accdb

HenrietteH
Alteryx
Alteryx
Created

32bit Access driver fails in tool config but workflow can still be run

 

 

Environment Details

 

  • This only affects Alteryx Designer versions 2023.1.1.123 and 2022.3.1.486
  • This only affects user with 32bit Access on their machines with a 32bit Access runtime (2013, 2016, or 365 runtime)
  • Existing workflow will continue to run
    • The following error will be thrown when the table list is refreshed with existing Input tools:

 

 

 

Get Table List Error: Error opening connect string: Can't create Data Source Object

 

 

 

  •  When mapping in a new Access file, users are able to map in the file, but they are not able to map in the table name

 

Cause

 

Defect TDCB-4655 was introduced when adding support for Access runtime 2016 and 365.

 

Resolution

 

  • Use a 64bit Access runtime
    • If 32bit Access is installed on the machine, Microsoft will not allow the 64 bit runtime to be installed. Access would have to be removed first
  • Map in the file through the UI and then add the tablename manually by adding three pipes ||| + tablename after the file name in the connection box:
    2023-04-18_17-29-36.png
  • The issue was resolved for newer versions. Upgrade to 2023.1.1.200 or 2022.3.1.508