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.

I can't edit my query.

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.

I can't save the result set as a table in my database.

I can't add, copy, or move a record in my database.