I have a problem on only one computer with this query :
SELECT Count(Call_ID) AS CompteDeCall_ID FROM dbo_Call WHERE Call_DateEntered > #2005-03-21#
It's a really simple query that count the number of item since a date.
on most computer it work, but one give this error Catastrophic Failure
i looked on the MS KB but nothing that worked...
I modified the query to test and this one
SELECT Count(Call_ID) AS CompteDeCall_ID FROM dbo_Call WHERE Call_DateEntered > Now()
the problem is the date maybe the # or the format or the computer...?
for information i'm using ADO 2.8 (both 2.5 or 2.1 given the same error)
the dbo_Call is a linked table on SQL Server 2000 using Access ODBC
I tried using DAO 3.6 and it crash.
the offending computer has Windows XP SP2