Problem when trying to access Mirosoft Access database from Qlik sense
I have installed Microsoft Access Database Engine 2010 Redistributable 2010 drivers to access our Microsoft Access database 2007 which is on a different server through Qlik sense app . while trying to create a OLEDB connection the windows integrated security is greyed out ... So we had to configure a ODBC connection and give specific username and password to access the database...
Any idea if I should have my user id a local user on the server from where I am accessing the Access database