Microsoft KB Archive/168522

= 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:


 * Import the table from the SQL Server into Microsoft Access.
 * Rename the table to the desired or original name.
 * Replicate the table to Microsoft Access with "No Data Synchronization".
 * Temporarily avoid using NULLs, by doing the following:


 * Update the NULLs of the datetime column to some other value.
 * Replicate the table to Microsoft Access.
 * 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

-

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

© Microsoft Corporation. All rights reserved.