How do I gain permissions to a Sql Compact Database?
- by Quenton Jones
I have an Sql Compact Database v3.5 that I'm bundling with my application. When the application is installed, the database is copied into the application's Program Files directory.
Because of Vista and Win7's security settings, the installed application can't access the database file. It is merely a problem of having the database file reside in the Program Files.
The solution I have thought of is to copy the file into Program Data, but does anyone have another solution? I am sure others have come across a similar problem.
Thanks in advance for your input.