ACC2: Error Message Running Query After Installing the Access 2.0 Two-Digit Date Update (245549)


The information in this article applies to:

  • Microsoft Access 2.0
This article was previously published under Q245549
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

After you install the Microsoft Access 2.0 Two-Digit Date Update, you may receive one of the following error messages when you run a query:
Invalid Date #0

-or-

ODBC-Call Failed

[Microsoft][ODBC SQL Server Driver][SQL Server] Line1: Incorrect syntax near '10' [#170]

CAUSE

You may receive this error message if you installed the Access 2.0 Two-Digit Date update and you are trying to use criteria against a date column in a linked ODBC table.

RESOLUTION

You can resolve this problem by downloading the update discussed in the "Status" section of this article.

STATUS

Microsoft has confirmed that this is a problem in the Access 2.0 Two-Digit Date Update. This problem is resolved by the latest release of the Access 2.0 Date Update.

For a complete list of the release history of this update and to download the most recent version, please see the following article in the Microsoft Knowledge Base:

231408 ACC2: Access 2.0 Two-Digit Date Update Available in Download Center

MORE INFORMATION

The Access 2.0 Two-Digit Date Update that causes this problem installs the following files: 
   File name      Version     
   ------------------------
   MSABC200.DLL   2.02
   MSAJT200.DLL   2.50.2819
   MSAJU200.DLL   2.50.2819
   Readme.txt     n/a

Steps to Reproduce Behavior

  1. Install the first version of the Access 2.0 Two-Digit Date Update.
  2. Open the sample database Nwind.mdb.
  3. Create a link to the Employees table in the sample database Northwind that is included with SQL Server 7.0.
  4. Create the following query:
       Query: TestDates
   -----------------------
   Type: Select 

   Field: EmployeeID
   Table: dbo_Employees
   Show: Yes

   Field: LastName
   Table: dbo_Employees
   Show: Yes

   Field: HireDate
   Table: dbo_Employees
   Criteria: #10/17/1993#
   Show: No
  5. On the Query menu, click Run. Note that you receive the error message mentioned in the "Symptoms" section.
Modification Type:MajorLast Reviewed:3/14/2001
Keywords:kbbug KB245549
©2002 Microsoft Corporation. All rights reserved.