I have the following scenario...
For the club that I play contract bridge at I also manage the computer setup which is responsible for gathering scores from the score entry boxes and calculating scores at the end of a competition drive.
The program installed at this computer also holds the list of members of the club along with some address information such as email adresses etc.
To be able to send a club email to those people, I wrote a little program that accesses this member list and uses the emailaddresses to send the email. The member list lives inside an access database file (let's say Members.mdb, stored along with the program's installation folder under "Program Files").
Now comes the problem... Running this email program under Windows XP is not an issue at all. It opens the database, fetches the emailaddresses and send the emails. Recently, There was an upgrade to Windows 7. The score program runs like a breeze, but suddenly, the email sender program does not find the Members.mdb file anymore. THis turns out to be a feature called "File Virtualization", since the file still exists, but is placed in a different location (AppData....VirtualStore...Program Files...etc) This folder is however user specific, so should not be hardcoded ofcourse.
The question is: Is there a (standardized) way to access files that are supposed to be in the protected (Program Files) area, but were actually stored in their virtual counterpart folders under AppData? My selfwritten program goes to the actual Program Files folder, while the calculation program stores the file in the "virtualized" location.
Any help would be appreciated!