We have Excel 2007 spreadsheets that are connected to Queries in Access 2007, in turn the Queries in Access have link tables to an SQL Server. The SQL Server requires the user to login with a user-id and password. In previous versions of Access and Excel, this was not an issue, the login screen would popup whenever it was required. Now this popup is not appearing and we're getting the error message : [Microsoft][ODBC Microsoft Access Driver] ODBC --connection to 'SQL ServerDatawarehouse' failed. This began after we converted all of our existing Access databases to the 2007 format (.accdb). We updated the Excel spreadsheets with the new drivers within the ODBC connections. Everything else is working fine, we even have connections to a different SQL Server that does not require a login and that is working. The Queries work fine within Access as we are getting the popup screen, this only happens when we call it from Excel.
