Anthony,

There should not be any reason why you can't use the OLEDB provider -we use both and have not noticed this problem.

Is the comma at the end of  the...

I think that what is happening is that the distributor is controlling the allocation of ranges. When a subscriber is created the distributor looks for the next free number (one...

We have done a lot of upsizing of Access/JET to both Access/SQL and VB or VB.NET/SQL.

If the application is big, then it is not usually cost effective to re-write the...

I am unconvinced regarding the use of merge replication for this task. Usually transactional replication is a better way to go (but for performance, don't put the distributor on the same machine...

Brian,

Thanks for the reply - I'm a bit reluctant to remove SP2 - It works fine on a colleagues machine (with SP2) so I'd rather try to get to the...

You can't directly modify an existing column's properties but you can add a new column or drop an existing column (see sp_repldropcolumn and sp_repladdcolumn in BOL). So you could creating a new column...

Paul,

Have you got the 'not for replication' option set on your identity columns? If not then this would give you this error.

Another option would be if you have inserted data with...

We had a lot of problems with Merge Replication over ISDN links. Admittedly there was a significant amount of updates going on but it still frequently 'failed to enumerate changes'....

Steve,

I agree with the general scope of your argument but one area where I have used encryption in the past is for credit card numbers. We developed a bespoke VB/SQL system...

Thorsten,

The details have now vanished into an electronic haze but the exact wording

of the original error were:

'The process could not deliver update(s) at the Publisher'

and we then got a non-specific 'General...

Paul,

Thanks for the suggestion - it's now looking like something in that area, although we are suspecting the comms links (it's over a WAN) as the problem has now mysteriously...