Microsoft KB Archive/245549

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

Article ID: 245549

Article Last Modified on 3/14/2001

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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
 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: <pre class="fixed_text">  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                   </li> On the Query menu, click Run. Note that you receive the error message mentioned in the "Symptoms" section.</li></ol>

Additional query words: pra

Keywords: kbbug kbfix KB245549

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.