BUG: Distribution Task Fails to Synchronize Access .MDB with Err

• Microsoft SQL Server, version 6.5

SYMPTOMS

When replicating a table from SQL Server to a Microsoft Access .mdb file, the distribution task fails to transfer the data to the .mdb file. The task history of the distribution task contains the following error message:

   S1000[Microsoft][ODBC Microsoft Access 97 Driver]
   Reserved error (-3033); there is no message for this error.

CAUSE

A datetime column of the replicated table contains NULL in the first record(s) and values in the following record(s). This is misinterpreted by the distribution task.

WORKAROUND

To work around this problem, do either of the following:

• Replicate with "No Data Synchronization", by performing the following steps:

  1. Import the table from the SQL Server into Microsoft Access.

  2. Rename the table to the desired or original name.

  3. Replicate the table to Microsoft Access with "No Data

        Synchronization".
  

• Temporarily avoid using NULLs, by doing the following:

  1. Update the NULLs of the datetime column to some other value.

  2. Replicate the table to Microsoft Access.

  3. When the tables are synchronized, update the datetime column back to

        NULL.
  

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.