How to restore ODBC data connection MS Access that stopped working?
Hi everyone, I had a connection to Access database that worked wonderfully, but suddenly it stopped working, the database is fine and if I try to connect from Qlik Sense desktop everything goes well, the problem arises when I create the ODBC connection From the Qlik server, sends me the following message "You do not have access to the data source", I have already tried deleting the connector and recreating it but nothing seems to work. Has it happened to you? I will appreciate your comments, thank you very much.
Re: How to restore ODBC data connection MS Access that stopped working?
I'm shooting in the dark here, but i would assume that your user is authenticating through domain controller (Windows AD for example) to the database, so your user can log in, but the server "user" so to speak can't since he has no user available to him.