Database settings configure how the current database functions. These parameters are stored with the database and may be different for each database. They include the listening ports, access rights to the Design environment, SQL configurations, etc.
Most of the settings are applied immediately. However, a few of them (such as the Start-up environment setting) only take effect when the database is restarted.
4D Server: Object locking occurs when two or more users try to modify the settings in the Database Settings dialog box at the same time. Only one user can use the Database Settings dialog box at a time.
Note: 4D provides another set of parameters that are applied to the 4D application: the user preferences. For more information, refer to the Preferences chapter.
You can access the Database Settings dialog box as follows:
- Using the Design > Database Settings... menu option,
- Using the corresponding button on the 4D toolbar
, - On 4D Server, using the Edit > Database Settings... menu option.
In the Preferences and Settings dialog boxes, parameters whose values have been modified appear in bold:

Preferences indicated as customized may have been modified directly in the dialog box, or may have been modified previously in the case of a converted database.
A parameter still appears in bold even when its value is replaced manually with its default values. This way it is always possible to visually identify any parameters that have been customized.
To reset the parameters to their default values and remove the bold style indicating that they have been customized, click on the Factory settings button:

This button resets all the parameters of the current page. It becomes active when at least one parameter has been modified on the current page.