Can An SQLite database be locked ? as in one cannot be opened externally and add rows to a table?

ok lets assume i have a table now it has only two rows in it and i dont want anyone to add any more rows to it? it can be accessed by c sharp but it should not be openable using SQLite ad开发者_JAVA百科min or any other db manager , is that possible??

I dont want the user to add another row outside c sharp can this be done????

triggers???

---

What connector are you using from C#?

If you are using System.Data.SQLite from phxsoftware it supports encryption. You could use that to prevent access to the database.

EDIT: As far a i understand it you will only be able to access it through the System.Data.SQLite connector then.