I am trying to use the Data Source Configuration Wizard to create a SQL Server connection with Local Cache and using the SQL Server Change Tracking but I keep getting an arror in the last step to create the local SDF copy saying there is a sharing violation and a different process might be using the file. The file it shows is the SDF its trying to create.

Any help would be wonderful. I am wanting to use this to sync data in the morning, use the application on a PC tablet to create records, etc. and then Sync bidirectional changes in the evening. I have most of the code figured out because I was able to get it to work in 1 table but not that gives the same error as well.

The new messages are: Connection to the database failed and Synchronizing the database failed both reference the sdf file might be in use.

Name:  Untitled.jpg
Views: 295
Size:  26.6 KB

Name:  Untitled2.jpg
Views: 266
Size:  26.7 KB