Troubleshoot Microsoft Query
Some of the content in this topic may not be applicable to some languages.
Creating and using data sources
I can't create a new data source.
I can't find or delete a data source.
Why does my data source have an asterisk next to it?
An ODBC driver that I used previously doesn't work.
Creating queries
I can't find the table I want.
I can't create the joins I want.
My joins don't give me the records I expect.
Microsoft Query won't let me edit parameter types for my SQL procedure.
Retrieving data
A message indicates that the path to my database is not valid.
Microsoft Query repeatedly runs out of time without connecting to my database.
Microsoft Query won't give me access to data in a Microsoft Excel list.
Microsoft Query continues to use connection resources while I'm not working with a database.
Microsoft Query does not return all of the available records.
Working in Microsoft Query
Why can't I continue to work in Microsoft Query?
Changes and formatting in my query aren't there the next time I run it.
Microsoft Query won't let me print the result set.
Microsoft Query won't let me make mailing labels.