Setting file persmissions for vista

Question

I have a .NEt 3.5 C# program written using VS2008 that uses a SQL Server CE database. I also have an installer for the program which I have created using the Visual Studio setup project type.

Within the program designer, the database file is included as type "content".

Within the installer program, the output for "content files" is the application folder.

This works fine on XP, but under Vista an error occurs when attempting to run the program. The error is that the program does not have permission to access the database file.

How do I fix this? Is there "proper" way to set this up in the installer project? Or do I need to write additional code in the application project? Do I need two different installer projects, one for XP and one for Vista? (Or 3, one for XP and one each for 32 and 64 bit Vista...).

And what about Windows 7, is that different again?

I am finding this very frustrating, as I only have an XP machine on which to develop and test.

T.I.A.