Column Limit in MS-Query

A

Andy Poljevka

A user had a query that used to work fine with about 200
columns. It now will not run. We kept deleting columns
in the query until it ran and it did so at 179 columns.
This issue is happening on XP and Windows 2000 in Office
2002 and Office 2000. The database that is being queried
is an Oracle database. The SQL runs fine in a normal SQL
tool.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum Fields in MS Query 0
MS Oracle ODBC failure in Access 07 3
Synchronization problems while moving folders to new email 1
MS Query keeps getting Out of Memory messages 1
MS Query File Location 0
Limitations on WHERE Clause in lookup query for a table column 1
problems with Access 2003 query 4
MS Query SQL File Location 3

Top