I'm trying to programatically change a SQL CE Database's password. I found that the only way to do this is by compacting the DB, by calling the Compact() method while passing a new connection string with the new password.
This seems to be working fine when I test it using the Emulator, but I get a "The specified module could not be found" error when I test it on a physical PPC device. The error seems to happen when the Compact method is called.
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The specified module could not be found."
Source="SQL Server Compact ADO.NET Data Provider"