I have been struggling for a while now on where I should put some SQLite3 database files that will need read and write access. You can see from my question that I am writing my app in WinRT, and that is where the problem starts. I have several choices on where to put the files, but they are all User level access. My app will have multiple users and I can not think of a way to share the same file amongst all the users. I have tried many ideas. None of them have panned out. Microsoft has WinRT so locked down as far as my ability to put files where I want them. I was thinking the ProgramData folder might make sense. But no.
Any one have a known, can't miss way for me to use any folder I want to, within reason? Next, I am going to try the Public User Documents folder and see if I have any luck using it. Not ideal, but I have seen other apps use it and I always wonder why. I am beginning to think I finally figured it out. Thanks for any thoughts you may have from a very frustrated coder.