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