Options Dialog Box

To open the dialog box, click Tools, Options, or press Alt-F7.

General Options

DBEdit Dialog Boxes - Options

Interface language: Use this field to change the DBEdit interface language.
Default data language: Use this field to set the default language for database data.
This feature requires configuring data translation in the database.
This workbook data language: Use this field to change the active workbook language for database data.
Encrypt connection string passwords by default: Check this option to encrypt connection string passwords by default.
If you encrypt the passwords, only you can connect to the database using the saved passwords, and only on this machine and under your account.
Encrypt connection string passwords in this workbook: Check this option to encrypt connection string passwords for this workbook only.
If you encrypt the passwords, only you can connect to the database using the saved passwords, and only on this machine and under your account.
Connection timeout: Use this field to adjust the server connection timeout.
Increase this timeout for busy servers and slow connections, or decrease it to receive connection errors more quickly.
Command timeout: Use this field to set the command execution timeout.
Increase this timeout if you're updating a large amount of database data.

DBEdit Dialog Boxes - Appearance Options

Default font: Use these controls to select the default font family and size.
Background highlight color: Use this field to choose a background highlight color for empty, NOT NULL cells.
ComboBox flat style: Check this option if you prefer flat-style ComboBox controls.
Set Calibri: Use this button to set Calibri as the default font.
Use Defaults: Use this button to restore the system default font.