The MSysConf table currently recognizes three configuration settings. These settings are activated by adding a record to the table for each setting. Currently, only the Config and nValue fields are used; the chValue and Comments fields are reserved for future use and are ignored in this release.
The following table describes the values you can use in the nValue field for each configuration specified in the Config field of your MSysConf table.
|
Config field value |
nValue field value |
Description |
| 101 | 0 or 1 | When this value is set to 0, the system doesn’t allow local storage of the logon ID and password in linked tables; when the value is set to 1, the system allows local storage of the logon ID and password in linked tables. The default value is 1. |
| 102 | D | This value, D, designates the delay, in seconds, between each retrieval operation performed by background population of a Recordset object. Setting a higher delay time decreases network traffic, but increases the amount of time that read-locks are held on data (if the server uses read-locks). The default value is 10 seconds. |
| 103 | N | This value, N, designates the number of records retrieved during the background population of a Recordset object. The default value is 100 records. |
Important If you create an MSysConf table, it must be set up properly or you will not be able to connect to the SQL database table at all.