Putting SQLite in local settings folder

[Guest]

Initially I was trying to install the SQLite to the application storage directory, but it fails in Windows7 and Mac while user set the default settings to install the app in program files. It fails to create asynchronous connection between database and application with admin privileges. How ever we can manage to create the SQLite in document directory  and it works for all(MAC & Windows7). Still to maintain a standard and reliability of the application MyDocuments folder is the convenient. So we tried to put it in local settings. But it seems air provides the method of creating temp files to point to local settings which behaves differently as it always create a new one when application initializes.  So the purpose of using SQLite DB fails as each time it create new SQLite file and install the default settings.

So currently we are targeting the users directory i.e "C:\Documents and Settings\user" in my machine and creating a directory with the project name and putting our SQLite files here. How ever it works in XP Professional and Windows7. Need to check for MAC,Linux & vista as well.

     But if anyhelp for putting the SQLite into local settings will be really appreciable. My sqlite data base is containing the application settings and I am going to change the settings and and update the SQLite sothat when application starts again it can keep the updated settings.

Thanks,

Alok

[Jeffrey_A_Wright]

Alok Mohanty, which Adobe product are you trying to utilize?  The inquiry above seem to be regarding SQLite.  For a list of Adobe products please review our product page.