I am getting a weird "ODBC Call Failed" error when trying to do an INNER JOIN on two Microsoft Access 2003 queries. The Access queries are going against a linked SQL Server 2005 table. The two queries are very simple, and both run without issue individually:
qryMEGAOVTM_Current:
SELECT...