I have a access database that has been built up over several years with many queries
Our normal usage is to write the query in MS Access that uses ODBC links to a SQL database and, after checking that the query output is correct in MS Access, use import data in excel using the "Get External Data" using the "From Access" button spreadsheet
About a month ago the ability to use the button stopped working and we now just get a message box the says "Microsoft Excel has stopped working" and excel is restarted
The error happens in early stages before available tables/queries are displayed
I am able to import the query data by using the "Get External Data" using the "From Other Sources" and then "From Microsoft Query" but this is cumbersome
I suspect the problem is a timeout or buffer capacity error but am unsure where to look
Can I have advice on trying to fix this problem please?