Use the MSysConf table in a Microsoft Access database with linked SQL databases

Use the MSysConf table in a Microsoft Access database with linked SQL databases

Note   You can link a table only in a Microsoft Access database, not a Microsoft Access project.

If you are administering an SQL database that uses Microsoft Access as a front end, then you can create a table in your SQL database named MSysConf to help you control communication between the two applications. The MSysConf table has two potential functions:

The structure of the MSysConf table

The SQL database table MSysConf should have the following structure.

Column name Data type Allows Null?
Config A data type that corresponds to a 2-byte integer No
chValue VARCHAR(255) Yes
nValue A data type that corresponds to a 4-byte integer Yes
Comments VARCHAR(255) Yes

Note   If the data source you're working with is case-sensitive, then use the table and column names exactly as shown.

All users must have permission to use the Select statement on this table, and only the system administrator should have insert/update/delete permission.

The data in the MSysConf table

There are three valid records in the MSysConf table. The following table shows what values you should enter in the Config and nValue field. The other columns are reserved for future use, and their contents are ignored.

Config nValue Meaning
101 0 Don't allow local storage of the logon ID and password in linked tables.
101 1 Allow local storage of the logon ID and password in linked tables.
102 D D is the delay in seconds between each retrieval.
103 N N is the number of rows retrieved.

Notes