Having a problem compacting my Access database when it's installed in user's program files folder. I'm using VS 2005 Visual Basic the user machine is Vista so I am aware of the restraints of placing something in the Program Files Folder, i.e., the virtual store etc...
So when I do a compact, as usual it requires a delete / re-name of the database at some point in the compact. The problem is Vista won't let you delete or mess with a database if it's in program files, even though all the action is taking place in the Virtual Store folder not actually in the Program files folder. I am aware I can install the whole thing in a different location like userAppData and it would work fine, but I want to give the user the option of installing in Program Files if they choose during setup.
Any suggestions would be much appreciated?