Matt,
Maybe you can get more info from:
Application.ODBCErrors
Application.OLEDBErrors

Show us your code for the QT.

NickHK

wrote in message
ups.com...
I have a query that runs fine in Microsoft Query, but when I try to run
the query as part of a QueryTable I get "Run-time error '1004':
Application-defined or object-defined error."

Are there any differences between these 2 ways of executing a query
that I am unaware of? Can I get more specific information about the
error?

Any help would be greatly appreciated.