You may find yourself in a situation where your 4D application is not behaving the way you expect it to. In some situations this can be caused by a corrupt preferences file(s). The preferences file(s) for an application typically stores the settings of any customizable features between runs, and if it becomes corrupted it can cause an application to crash or otherwise misbehave. The easiest way to diagnose preference file trouble is to move the file(s) from where the application is expecting to find them, thus causing the application to recreate a default preferences file from scratch. If this does not help you can simply move them back.
For 4D v11 SQL the preferences files can be found at the following locations:
C:\Documents and Settings\All Users\Application Data\4D
Mac OS X:
You can safely move the entire contents of these directories on a PC or Mac with the exception of the "LICENSES" directory which contains the registration information for 4D v11 SQL; if the LICENSES directory is removed you will need to re-register your 4D software. Depending on whether or not you have created any macros you may also want to preserve the MACROS V2 folder.
On Mac OS X there are some additional preference files that can be found in the following locations:
You can safely move any of the files in those locations starting with either 4D* or com.4D.* to a different location on your machine. If this does not help you can simply move them back.
The 4D Client structure cache