Synchronization failing

[jonnyboy]

Hi,

I have a design master for a back-end database on the hard disk of my computer and a replica on a network share.

When I try to synchronize the database, I get an error 3008:

The table "|" is already opened exclusively by another user or it is already open through the user interface and cannot be manipulated programmaticall y.

Neither the design master nor the replica are open by any other user.

Anyone with any ideas please?!

[jonnyboy]

Solved it - it came about by changing the data type of one of the fields from 'hyperlink' to text. I successfully replicated the problem. So, if you ever have a 'hyperlink' field in a replicated table, DO NOT change its data type!

[NeoPa]

Thanks for posting your solution. That helps to clarify things for the next one who's looking at the same problem :)

Welcome to Bytes!

[jonnyboy]

I've also noticed this happens sometimes when changing data types in general. So, if you need to change a data type on a design master, ensure all of your replicas are checked in before doing so! If this isn't possible, you will have to create new fields and use an update query to copy the information over from the old field.