sql server replication: What happens whey you try to edit the data in these
tables - any error messages etc? How are you editing
them - using Enterprise manager? (If so you must move off
the line for the edit to be committed).
Regards,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi,

I have a transactional replication setup between two SQL Servers. Only some
of the tables are required to be replicated.

The problem is now that on the publisher which is linked to MS Access, the
tables that are not replicated cannot be updated for some reason. However I
can update these through Query Analyser.

Can someone please tell me how to resolve this issue.

Thank you.

Hi Paul,

Manage to find the problem. An index was missing from the table which
prohibited MS Access from updating a row.

Howevere I was always able to edit a row using MS Query Analyser

Thanks



[quoted text, click to view]