Help with Vista/Win7 and Virtualization

[FlyBoy]

I'll appologize up-front, I know this isn't the place to ask, but I've been playing with the Window7TrainingKit and searching MSDN and I'm a little bit stuck and so I'm going to throw this out there, any help or direction will be appreciated...
Windows is virtualizing some of my files and I'm not sure how to get around it. The app I'm deploying writes to a SQLAnywhere database file. I'm deploying all the program code to the c:\Program Files(386)\... folder and deploying the db file to the C:\ProgramData\.. folder. I'm embedding the manifest file in the .exe. If I set the manifest to 'As Invoker', then windows virtualizes the .db file in the C:\ProgramData folder (not what I want). If I set the manifest to 'Highest Possible' then I get the prompt "Do you want to allow this app" from windows when you run the .exe - but then my .db file doesn't get virtualized (this is better). I can't have that file virtualized or it will create problems for me down the road.
If I get a certificate and sign the app will I be able to set the manifest to 'As Invoker' (thats all I need) and have UAC leave my .db file alone? From what I'm getting on MSDN I should be putting the files I'm writing to in the ProgramData folder.
Bottom line what I need is the manifest set to 'As Invoker' (so the windows prompts to continue don't come up), and for windows to not virtualize the .db file!!! Thanks for any help or direction.

[pww]

I solve virtualization problems by setting 'Full control' permissions for the 'Everyone' user for the folder where the files I don't want virtualized are.
See this
http://www.indigorose.com/forums/showthread.php?t=16092

Note that if at the time you set full control permissions a virtualized file exists, Vista will keep using it - so you should as well delete the files/folders that belong to your app from the VirtualStore folder (or move them to the real folder).

[FlyBoy]

PWW - Thank you. That will work if I can make the folder where the DB and xml config files are going open to Everyone. Do you know if SetAcl will continue to work with Win7???

Thanks again.

[pww]

yes, as far as I can tell it works, there seem to be no changes in ACL related stuff in Win7. There were no problems with the tests I did, I also use it in two setups and there are no problem reports from users so far.