Avatar of tim7

asked on 

Compact Access Database - Problem with Vista Program Files Folder

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?
.NET ProgrammingMicrosoft AccessVisual Basic.NET

Avatar of undefined
Last Comment
Scott McDaniel (EE MVE )

8/22/2022 - Mon