Microsoft KB Archive/168522

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:04, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

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

Article ID: 168522

Article Last Modified on 10/3/2003


  • Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q168522

BUG #: 16831 (6.5)


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.


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.


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.


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