There are many possible causes that can crash MSQuery in office 2010. A typical crash is as below:
AppName: msqry32.exe AppVer: 14.0.4750.1000 ModName: msvcr90.dll
There are several possible resolution you can try to resolve the above crash:
1. When you launch MS Query, just disable the option "Validate queries before saving or returning data", this is the fifth box in the options menu.
The only problem is that if you have made any mistake in your query, you'll only be noticed when receiving the data in excel.
2. Repair all the keys into registry at the following place:
Windows Registry Editor Version 5.00[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC]"TraceFile"="C:\\DOCUME~1\\...USERNAME...\\IMPOST~1\\Temp\\SQL.LOG""TraceDll"="C:\\WINDOWS\\system32\\odbctrac.dll"
In some cases ODBC trace/analyze log is off and can't create a big SQL.LOG file size that cause msvcr90.dll crash