If you have to change the code to refer to a different name as you have to add the instance details, you might as well have a different name for...

Is ACTIVITY_UID  a GUID?

It looks like you have duplicate ACTIVITY_UID so there is a confusion over which record you are trying to update because there is more than one record...

I've seen this before when a change has been made to the data but the screen has not refreshed, when you refresh the dataset the data is shown cleanly. It...

I've seen this before when a change has been made to the data but the screen has not refreshed, when you refresh the dataset the data is shown cleanly. It...

You need to fix orphan users. There is a script on this site http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1605 or you can find a script on the Microsoft site somewhere.

Regards

Carolyn

Try using a pass-through query in access, rather than a linked table, and use the with (nolock) hint in the query to be doubly sure, though not sure you will...

Been there got the T-Shirt.

Script out the delete for the replication and extract the lines that refer to the view. Drop the view from being replicated. Then you can get the...

Thanks I thought that should be the case, but am testing as there have been some issues with missing data.

Regards Carolyn

I ran it from the downloaded bat file, and the instance name was in the dropdown list as STARTEAM.

Regards

Carolyn