Deploying A WinForms Application With SQL Server Compact 3.5

Hi

I create a small aplication to lookup postal codes, it uses only some basic queries. It's a Winforms (using Visual Studio 2008) application, as MS put as local datase SQL Server Compact 3.5, I use it.

The application works fine it has only tree tables (with the postal codes of USA, Canada and Mexico) using the SQL Server Compact 3.5 database file.

I create a setup project and made and installer, in this case I follow the indications from MS to copy to the application folder alld the SQL Server dll files needed.

In Windows XP, the aplication works fine after installation. But in Windows Vista not. I found that as the installer put all files unde C:Programa filesMy CompanyPostal Codes folder, the application need's administrator permission to run.

I don't know how to change the database file to another location in order to avoid this problem.

Do you know how to avoid this? Maybe using a different path for my database file (if this can you tell me how to make the connection string to works properly) Or making the app to requires the administrator permission (I know tha in VS 2008 this can be done, biy not idea of how?

Thanks for you valuable help.