PRB: SQL Server 2000 Views Not Replicated to Microsoft Access Through Merge Replication (318241)

MORE INFORMATION

Steps to Reproduce the Behavior

Follow these steps to reproduce the behavior:

1. Create a database, named DB, on SQL Server 2000.
2. 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')
   					

3. 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
   					

4. Create a blank Microsoft Access database and name it ADB.
5. Set up Merge Replication on SQL Server by using table T and view T_view.
6. Set up a push subscriber to the Microsoft Access ADB database.

The Merge Agent reports "succeeded"; 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.