Out of this page by Microsoft about Sql Compact Edition database encryption
The password does not prevent the reading of any data in the database file as clear text. By using both encryption and a password, you can store the data in an encrypted format and restrict programmatic access to the database.
so, just to get it clear.. after password protection and encryption of the database, the data might be still readable in some ways? and the only thing blocked is the programmatic data connection?
so if someone has this encrypted and password protected database, he/she could read the data in it? what is the sense in that?
Someone please clear this up to me? Thanks!
The MSDN article states, that just password protection is not sufficient to prevent someone from opening the database file in e.g. a text editor and recovering the stored plaintext. If the database is encrypted (and therefore also password protected), its contents should not be recoverable without providing the password (i.e. opening the database file will show only 'scrambled' text).