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

• Microsoft Access 2.0

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 this to be 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:

Q231408 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.

Additional query words: pra

Keywords : kbdta
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type : kbbug