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

Retired KB Content Disclaimer

View products that this article applies to.

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]

Back to the top

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.

Back to the top

RESOLUTION

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

Back to the top

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 (http://support.microsoft.com/kb/231408/EN-US/ ) ACC2: Access 2.0 Two-Digit Date Update Available in Download Center

Back to the top

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

Back to the top

Steps to Reproduce Behavior

Install the first version of the Access 2.0 Two-Digit Date Update.
Open the sample database Nwind.mdb.
Create a link to the Employees table in the sample database Northwind that is included with SQL Server 7.0.

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

On the Query menu, click Run. Note that you receive the error message mentioned in the "Symptoms" section.

Back to the top

APPLIES TO

Microsoft Access 2.0 Standard Edition

Back to the top

kbbug kbfix KB245549

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top