Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/168522

From BetaArchive Wiki
Knowledge Base


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

Article ID: 168522

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q168522

BUG #: 16831 (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.



Additional query words: replication jet odbc

Keywords: kbbug kbinterop KB168522