Hi Debra.
>Doug - can you recommend where the data should be stored? We are in the process of making our database application Vista compatible. I have read all about virtualization and am not interested in going this route. I am going to manifest my exe with "asInvoker". Right now, everything is stored in C:\Program Files\MyAppName\. The database is in the C:\Program Files\MyAppName\Data folder. I know under Vista this will not work - can't write to any files under C:\Program Files. I'm not sure where the data should live in order for multiple local user accounts to access the same database.
My current thinking is in a subdirectory of C:\Users\Public. You can find that folder on Vista, XP, or earlier releases by passing "Personal" to the program I published in
http://doughennig.blogspot.com/2007/01/finding-paths-for-special-folders.html and then use its parent folder as the root for your new folder.
I'm also putting some data into a Data subdirectory of my app folder and having the installer change permissions for that folder to make it read-writer.
>Also, I have a few instances where I create user specific temporary tables for report purposes and I don't know where these files would be created either.
You can create those in the user's temp folder, which SYS(2023) will give you the path for.
Doug