Catastrophic Failure

Posted on 2005-03-21
Medium Priority
Last Modified: 2012-05-05
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()
work fine.
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
Question by:numeriss
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 51

Accepted Solution

Steve Bink earned 2000 total points
ID: 13593948
It could be the absolute date reference is confusing Access.  Access is SUPPOSED to be able to identify different date formats with no problem, but the reality is somewhat different.  Try using the DateValue() method to provide the comparison value:

SELECT Count(Call_ID) AS CompteDeCall_ID FROM dbo_Call WHERE Call_DateEntered > DateValue("3/21/2005")

Also, here's some documentation from the help file.  Make sure you check your date format settings:

DateValue recognizes the order for month, day, and year according to the Short Date format you specified for your system. DateValue also recognizes unambiguous dates that contain month names, either in long or abbreviated form. For example, in addition to recognizing 12/30/1991 and 12/30/91, DateValue also recognizes December 30, 1991 and Dec 30, 1991.
LVL 41

Expert Comment

ID: 13593962
These links may be of use to you:

It looks like you need a hotfix from MS.

Expert Comment

ID: 13594604
Is there any chance of a regional settings issue here?

Author Comment

ID: 13594641
the DateValue worked, but stripped the Time of some of my dates.
so I simply used the CDate fonction and it worked...

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question