I have an ODBC source on an Access db that I'm trying to use to get data into Excel. When I get to the 'get data' step in either the pivot table or the 'new database query' wizard, I get an message that msqry.exe has crashed and 'an error log is being generated'. The whole setup works fine in a test environment (different computer, different network)
1. Does anyone have any idea why the odbc link should be failing like this?
2. Where is the error log for MS-Query? I've looked high and low, but can't find it.