Microsoft KB Archive/318241

= PRB: SQL Server 2000 Views Not Replicated to Microsoft Access Through Merge Replication =

Article ID: 318241

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q318241



SYMPTOMS
SQL Server 2000 views are not replicated to Microsoft Access 2002 or Microsoft Access 2000 databases through Merge Replication. The Merge Agent reports &quot;succeeded&quot; but does not replicate views to the Microsoft Access subscription database. No errors are logged.



Steps to Reproduce the Behavior
Follow these steps to reproduce the behavior:

 Create a database, named DB, on SQL Server 2000.  Create a table, named T, in database DB such as: Create table T (c1 int identity, c2 char(20)) Insert T (c2) values ('one') Insert T (c2) values ('two') Insert T (c2) values ('three')   Create a view named T_view such as: CREATE VIEW [T_VIEW] AS SELECT [dbo].[T].[c1], [dbo].[T].[c2] FROM [dbo].[T] where c1 >2  Create a blank Microsoft Access database and name it ADB. Set up Merge Replication on SQL Server by using table T and view T_view. Set up a push subscriber to the Microsoft Access ADB database.</ol>

The Merge Agent reports &quot;succeeded&quot;; however, only the T table is replicated to the Microsoft Access ADB database. The view T_view is not replicated.

The output of the Merge Agent shows that the views are not included when the snapshot is sent to the Microsoft Access subscriber. This behavior is seen only for Merge replication. With Transactional Replication, you can replicate SQL Server views to a Microsoft Access database as queries.

Keywords: kbprb KB318241

-

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

© Microsoft Corporation. All rights reserved.