Search code examples
ms-accesscompact-frameworksql-server-ce

Access Database Synchronizer with network location

Using the Access Database Synchronizer has anyone been able to synchronize with an mdb stored in a network location?

It doesn't even work if i map a network drive to my local c: i.e. c:\test.mdb works but z:\test.mdb doesn't.

I simply get a System.Data.SqlServerCe.SqlCeException "Failure to open SQL Server with given connect string."

Solution

  • Old question now. Seems as though no-one has an answer (or even heard of it).

    Access Database Synchronizer won't work when using a network drive, most likely a bug in the product.