ODBC Call Failed from Access 2003 Query
Posted on 2007-10-18
XPSP2 w Office 2K3. Access 2003 Front End, SQL 2000 SP4 Back End. I have to know why my fix worked here. I had a trial balance report that worked fine until yesterday we started getting ODBC call fails. I isolated the query that ran and the table and column causing the problem. In fact if I just elimniated the criteria on the column it ran fine but returned the wrong dataset. The field is a 'bit' field and the criteria was 'True'. This is working in all kinds of other queries, tens of which are in the GUI, using the True/False criteria. The table is nested #4 referentially left to right. It still is.
If I simply change the criteria from True to - get this - >0! SQL stores 1 or 0, Access shows -1 or zero respectively, so I get the math but when did the True/False thing stop working?
I have deleted the table from the query re-compacted, deleted the linked table to SQL and relinked and re-added the table to the query. Same result.
NOTE: If I make a separate query with just that table and the True/False criteria reference, it works fine! Also, I make back up copies of the .mdb file everyday during development as revisions warrant it. The query worked fine in the back up .mdb but when imported into the current .mdb as an imported object it fails. Any guesses?