Install an application and database for all users

Question

I'm trying to use the latest inno setup to deploy my program. It seems I can't (and not recommended) to install my program to Program Files folder due to the restrictions it's going to give (for example my program will always have problem using the part of the program which modifies database, unless it's started as an admin). I read somewhere that we should ask inno setup to install our program at CSIDL_APPDATA but i'm not really well versed with inno setup. How do I do this using Inno setup?

Answer 1

The application itself should be installed into a folder underneath {pf} (Program Files). Application data (or a database) however should go into a folder underneath {commonappdata}. If the database is to be modified by normal users, then you'll need to set the permissions on this folder (using the Permissions parameter). If it's user specific, they can copy the default to the user's appdata folder and modify that.

[Dirs]
Name: {commonappdata}\i-Catcher Console; permissions: everyone-modify admins-full;

The complication comes when using an Access application that has the UI built into the database itself. In this case both locations are just as bad as each other ({commonappdata}/blah is marginaly better) but you will need to set the permissions as appropriate.