I have a series of Excel workbooks serving as report containers for an Access database. We are in the process of migrating this from one to many users and, as a result, need to add user-level security. While all other functionality seems unaffected by the change, when we try to open the Access queries in Excel using VBA to refresh the QueryTable, the following message appears:
"ODBC Microsoft Access Driver Login Failed"
Even when I try to log into the database after receiving the error message, I get the same error. But, when I refresh the QueryTable manually with the user interface, it seem to work just fine.
"ODBC Microsoft Access Driver Login Failed"
Even when I try to log into the database after receiving the error message, I get the same error. But, when I refresh the QueryTable manually with the user interface, it seem to work just fine.