What are the advantages in installing my application in C:\Program Files

What are the advantages of installing my application and backend database in Program Files and Program Data rather than my own Folder in the C-Drive?

Thanks in advance

Clive
Clive BeatonAccess DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You would probably have to work out how users would have access to a data folder in the C drive (unless "Everyone" does).

Installing in Program Files and then data in Program Data normally allows the program easy access to the data with normal user permissions.  That would be a key reason.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tom CieslikIT EngineerCommented:
No Advantage !!!!
You can install in any private folder you want if installer will allow you to do it.
Microsoft just created Program Files folder to organize all programs in one place.

Imagine if any programs would install in any folder,,,,, after 3-4 years of using computer you would have few hundreds folders on C drive.
0
Dr. KlahnPrincipal Software EngineerCommented:
The application should certainly be located in the standard location for Windows executables, which is either C:\Program Files or C:\Program Files(x86).

The database files you can put wherever you like, and there are both advantages and disadvantages to not keeping them on the Windows drive.  Among those advantages is that Windows backups are smaller since the entire database isn't backed up when you back up the system drive.  Among the disadvantages is that the entire database isn't backed up when you back up the system drive.  Only you can judge what works for your application.

However.

If the database is going to be big or if there is going to be considerable ongoing disk traffic on the database, it is worthwhile to splurge $50 and buy a second hard drive to keep those files on a separate disk.  That will allow continuous access to the database without impacting normal system operation, and vice versa.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

arnoldCommented:
The point being conveyed is program files have predefined permissions that when you install an application those permissions are inherited by the newly Instalked product.
Should you install the application in any other location, you would have to make sure the permissions are set correctly to allow regular users access without the right to modify, delete.

Similarly programdata has write permission to users....

Access .... Has to have rights granted to user ...
If you use an SQL express instead, the users will be accessing through the SQL server application that will authorize the user.

Difference, a user could delete the access file while the SQL server, the user can only do what the application they are using to access the data allows.
0
Dave BaldwinFixer of ProblemsCommented:
I put 'normal' programs like editors in the 'standard' directories in C:\Programs... because that is where they are expected to be.  I put programs that require a lot of external access into their own directories in C:.  This include webservers like Apache and development apps like WAMP and XAMP.  Note that IIS has it's own directories in C: for similar reasons.  I have MS SQL Server in C:\Programs but the database files for web apps are in the web directories.
0
arnoldCommented:
Placing db files in the web directory is unnecessary as access to files is granted by the application and is in my view a poor placement choice.
DBS should be separated and stored in locations accessible only by the application, MySQL, ms SQL...
0
Dave BaldwinFixer of ProblemsCommented:
That's probably true with SQL Server.  I started doing that with Access mdb's because that was the only was to open them.
0
Clive BeatonAccess DeveloperAuthor Commented:
Thank you all.  A great help.

Clive
0
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.