I have a select query that has not been modified recently but when I run it I get an error message "Too many fields defined." The query is based on two tables that also have not been modified recently. Neither table exceeds the 255 field maximum.
I've compacted and repaired the front end and the back end databases, and I re-created the tables using copy/paste structure only and appended all the records from the original tables. No luck. Any suggestions?