Skip to Main Content
Product Suggestions
Categories Access Dimensions
Created by Guest
Created on Aug 5, 2021

Generate Access Dimensions ODBC when setting up Automation Manager

When 365 Automation manager is set up for Access, we have to manually create the ODBC to connect. This can sometimes be misconfigured to use the same as Access (SQL SERVER NATIVE Client 11.0) when it should be using SQL SERVER.

This causes import issues, such as invalid comparison between VARCHAR and TEXT in import item Stock Item UDF, as an example.

  • Attach files