If I am not given administrative rights on my PC will Apex still run?
Edit 7/29/2014: If you are installing Apex 10.8 or above you do not need to worry about these installation options. Simply install Apex from the installation CD (or network share).
If you are not given administrative rights to your computer, Apex may not have permission to write to files that it needs to use to configure the database engine, store your user preferences, and other issues.
Apex can be easily configured to run without administrative rights and permissions, but the administrator that installs the Apex program on your computer needs to perform a few additional steps.
- Ensure all users have full access to the BDE directory. By default this is at c:\program files\common files\borland shared\bde.
- By default, Apex tries to write a small amount of information (called the Schema Cache) to the Windows directory. For Apex to operate correctly you need to either: grant the user full access to the Windows directory, move the Schema Cache to another directory where the user has full write acccess, or disable the Schema Cache. To move or disable the Schema Cache use the BDE Administrator to edit the ApexCS database alias and set the Schema Cache Directory or set Schema Cache to FALSE. (Ensure that it is still FALSE when you log in as a non-admin user.) Note that disabling the schema cache will slow down performance slightly when Apex opens new forms.
- Ensure that all users have full read/write access to the [HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine] registry key. (Note that by default they probably don't.)
- The Apex.ini file stores local workstation configuration settings. The Apex user will need to have full access to this file, which is located in the Windows directory.
The administrator should run Apex at the end of the installation and make sure that it operates correctly. Then, if a non-administrative user has trouble we know for certain that the problem is a file or registry permission problem.