Hi Pete,

I have run into this problem before.

It seems to be cause by Access picking up the wrong primary key, due to the way the indexes are named.

If you run...

Hi,

I would think that Merge Replication is the way to go for you, because with Transactional and Snapshot replication, the subscriber cannot make changes to the data.

You can put the...

Hi Sunilv,

Looking at your post, I think merge replication is the only option, because you want the subscribers to be able to enter data locally and then have that data...

Hi Dale,

Changing the IP address should make no difference. Replication relies on the machine name not the IP address. So if the name has not changed you should not have...

Hi ya,

What you need to do is create 2 publications. One for each subscriber.

Each puplication should have a rowfilter on the Sales table, assuming you have a field that identifies...

SQL Express does support a pull subscriptions.

What you cannot have is SQL Express as a publisher.

Neil